The data sheet has >25,000 rows. It has price and vendor name. This information needs to be transferred another tab to the exact matching row identified by partnumber. The sheet is not sorted nor consistent in terms of in which row/column the price and vendor names are. I am not sure if it can be done, but I think a nifty VBA code might do the trick. I attached the sample data.
19 freelancere byder i gennemsnit $69 på dette job
Greetings California from Pennsylvania.. 20+year MsExcel programming expert with strong business application background. Please see PMB. Respectfully, Bill.
Greetings, I work full time with VBA and all flavours of EXCEL on a daily basis - as a senior developer. I am confident I can provide the solution you require. Thanks. Anil