We are in need of an Excel macro to accomplish the following:
We have a master spreadsheet that contains item ID's along with other columns of associated information. This is a multi page (tab) master spreadsheet.
We have a separate .csv file that contains only item ID, quantity.
We need the macro to:
read the .csv file,
find the corresponding item ID in the master spreadsheet from among all of the pages (tabs),
and insert the quantity from the .csv file into a specified column of the matching item ID row in the master spreadsheet.
26 pekerja bebas membida secara purata $56 untuk pekerjaan ini
I understand project description completely. This is my first bid on Freelancer and would welcome the chance to do this project for you. I have 15 years Excel VBA experience and many completed projects.
Hi, I have an almost completed WORKING SAMPLE of what you need which would just need minor changes. I am attaching the sample for your review in your PMB. Please see if it suits your needs.
Hello. I am an experienced Excel user and VBA programmer. I can write the script that you have described to automate the search and data entry task. Please contact me to proceed.