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.

Evner: Excel, Excel VBA, Excel Macros

Se mere: 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

Om arbejdsgiveren:
( 31 bedømmelser ) Lindenhurst, United States

Projekt ID: #21910167

Tildelt til:


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 Flere

$20 USD på 1 dag
(14 bedømmelser)

5 freelancere byder i gennemsnit $30 på dette 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 på 1 dag
(109 bedømmelser)

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] Flere

$20 USD på 1 dag
(9 bedømmelser)

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 Flere

$50 USD in 7 dage
(10 bedømmelser)

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 dage
(0 bedømmelser)