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.
Hello, I see you require an Excel macro to get the matching item ID's quantity value from the CSV file to the Excel spreadsheet. Furthermore, it needs to add read and add where necessary on multiple tabs in Excel workbook. I have sent your a private message about my skills and previous experience in similar projects. I rest-assure that I will complete the work on time and deliver your the completed work to your satisfaction. I will also make the installer to install this macro easily to Excel as the same way uninstall it.
$55 USD en 2 días
5,0 (20 comentarios)
4,6
4,6
24 freelancers están ofertando un promedio de $58 USD por este trabajo
I plan to complete the project via writing an Excel macro contained in a separate XLSM file.
This approach makes further use of the macro very convenient by offering a Control sheet to identify the current input files. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. If you send me sample input files, I'm ready to create a draft pilot in order to make sure everything is rightly understood.
Regards!
Hi,
I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I am interested to work for your project. I will make sure that I deliver you the best with 100% accuracy in minimum time . Pay me only if you are 100% satisfied with my work, after project delivery. Please see my private message(PM) and sample projects attached with PM for reference.
Regards
Fibin
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,
Your project ready for delivery.
Check out this BONUS money winning spreadsheet which I did recently. This spreadsheet processes .csv files and saves a report at specified path.
If you like the spreadsheet, send me a mail and I will modify this according to your requirements and send it to you.
Note: Please check your INBOX for file. The file is in EXCEL 2007 format
Regards,
Naveen
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
Me an Ms-Excel Expert working on MS-Excel & VBA for the past 12 years. I am ready to do your work and could start right now. I have already done a no. of successful Excel Projects and can provide u sample copies if you so desire. U can expect quality work in time.
Thanks
Hello
I can do this for you, I have experience and expertise in MS Excel and macros. I have already developed similar program done, just need small modifications and I'll provide it to you.
I can do it quickly and accurately and you do not have to make any payment until you are completely satisfied.
Please see my profile and feedbacks.
Regards
Faisal
Hi, I'm really interested on this job. I'm a hardworking person available to work day and night with a past internet connection. hope you will consider me as one of your freelancer member.
