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.
13 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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
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