I have 5 yrs worth of sales in an excel sheet. It is 65,000 SKU numbers from 2014 - 2019. Then I have a master list of just shy of 2000 SKU's. I would like column D filled in on the Matrix sales workbook with total unit sales for each vendor Part # from Matrix sales column F. It would be matched up with the vendor part#'s from column G of the 5 yrs workbook. Then I would like the sales broken down by year in column E-J.
I am expecting that many of the vendor part #'s in the Matrix sheet may not have sales. I am also expecting a lot of the "Vendor part #'s" from the SKU's sold 5 yrs workbook will not match up to the Matrix workbook. I would like any vendor #'s that do not have a match to be put into the Missing vendor #'s tab. All of the data from the row should accompany the missing part #'s.
I believe this is pretty straight forward and not to involved.
5 freelancers are bidding on average $30 for this job
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.
Professional with training in Informatics, administration and Finance, highly efficient, effective and responsible, I have experience in data entry, analysis, programming, customer service and sales