Excel VBA coding assignment

Given the file "[login to view URL]"

You will do this all in VBA

1. Determine how many (total) of each product were sold. List this information on a second spreadsheet.

2. Determine the total SALES amount for each product. This will be the quantity times the unit price which is given. post (on the first spreadsheet) the total sales amount next to the total qty sold for each product. This will be column E. Note that there are two stores. So it will be the sum of the two stores qty times the unit price.

3. Display the number of sales (quantity) by product for each of the two stores - Store A and Store B. this is similar to #1 above.

Note: Arrays can make this simpler.

Taidot: Excel, PHP, tietojärjestelmäarkkitehtuuri, Visual Basic, Visual Basic for Apps

Näytä lisää: vba projects for beginners, 2500 excel vba examples free download, excel vba programming examples download, excel vba practice exercises free download, vba practice exercises for beginners, excel vba practice exercises pdf, excel vba programming for dummies, vba tutorial, excel vba open xml file, create xml file excel vba, excel vba coding ftp connection, importing excel file access database excel vba, export excel file access database excel vba, excel vba write xml document file, excel vba read write xml file, excel vba import data csv file, excel vba export range text file, excel vba external link future file, excel vba examples insert csv file, excel vba worksheet names external file

Tietoa työnantajasta:
( 0 arvostelua ) Federal Way, United States

Projektin tunnus: #19564100

Myönnetty käyttäjälle:


Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at I can write a clean VBA code for you which will provide you with the Lisää

$25 USD 1 päivässä
(95 Arvostelua)

13 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello? It's a pleasure for me to have a chance which I can work with you. I am clear with the description in Excel project like this. I've worked a lot of jobs with it. So I think I can help you if you want. This is E Lisää

$50 USD 7 päivässä
(155 arvostelua)

Hi, I will create Dashboard type report for you, which will update based on new data. You can filter report by just clicking buttons. Filters will be like.. show sales for Both store or any particular store. Lisää

$30 USD 1 päivässä
(267 arvostelua)

Feel fee to contact me for Excel VBA coding assignment .Shoot me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the [login to view URL] payment onl Lisää

$50 USD 3 päivässä
(47 arvostelua)

Hi, Greetings. Here is sample of the no of each product sold: [login to view URL] Let me know if you are interested. Thank you.

$30 USD 1 päivässä
(105 arvostelua)

Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards

$111 USD 3 päivässä
(57 arvostelua)

Hi, nice to meet you. I am Ruyun and always ready for you. After reading your description carefully, I have convinced that I can complete this project in time perfectly as you want. Because through over 7 years, I Lisää

$200 USD 1 päivässä
(12 arvostelua)

Hi, How are you today? I have just read your job description carefully and I am very interesting in your job. I am a senior Excel,VBA,C,C++ ,C# developer with 10 years experiences and I have developed many program of u Lisää

$25 USD 7 päivässä
(53 arvostelua)

Dear sir, madam I am interesting your project. I can satisfy you perfectly. I have read your description and I would like to work for you having perfect expertise in required task. I am software engineer having 5 year Lisää

$45 USD 1 päivässä
(4 arvostelua)

Hello! I understand the requirement. The proposal includes the macros required for you to generate the summary automatically. I can gladly give you additional detail of any experience you wish to verify. Responsibilit Lisää

$40 USD 1 päivässä
(3 arvostelua)

for web design - website and all other web development . ----------------------------------------------------------------- I am a Full Stack - mean Stack Developer 16+ yr. Exp. I can develop web & Mobile apps. W Lisää

$750 USD 5 päivässä
(0 arvostelua)

Daty entry

$25 USD 1 päivässä
(0 arvostelua)

Experience with VBA and Macros at SAP working with databases. From what I read in the description it won’t take more than 2 days since its really easy A hit for sure

$27 USD 4 päivässä
(0 arvostelua)