Cross reference and compile sales by SKU

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.

Skills: Excel, Excel VBA, Excel Macros

See more: zen cart cross reference, sybase cross reference tables, oscommerce cross reference products, modine radiator cross reference website, php cross reference oscommerce, cross reference sobi2, autoparts cross reference search, oscommerce cross reference, px26d cross reference, osram 21w 7506 cross reference, cross reference longitude latitude full address, automatic update cross reference visual basic word, toner cartridge cross reference, cross reference list printers toner cartridges, cross reference, cross reference address latitude longitude, database printer cartridge cross reference, forum toner cross reference database, hp laser printer cartridge cross reference

About the Employer:
( 31 reviews ) Lindenhurst, United States

Project ID: #21910167

Awarded to:


hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myse More

$20 USD in 1 day
(14 Reviews)

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.

$30 USD in 1 day
(109 Reviews)

Feel fee to contact me for Cross reference and compile sales by SKU .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] More

$20 USD in 1 day
(9 Reviews)

Hi, I have gone through your requirements and I can do this task. The skills and resources needed for this project are in my genes. I can assure you for a complete professional work in given time [login to view URL] share comp More

$50 USD in 7 days
(10 Reviews)

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

$30 USD in 2 days
(0 Reviews)