I would like to hire an Excel Expert for one page code project (Visual Basis) - 12/07/2017 04:07 EDT
€8-30 EUR
Completed
Posted almost 7 years ago
€8-30 EUR
Paid on delivery
Hi, I need a visual basic code to compare multiple workbooks to each other in excel and have the matching Names data copy the entire rows into a new workbook. eg: If a name matched in 2 or more workbooks, the report page will have all rows for that name (one from each workbook where the name found).
Please note
1. The minimum workbooks to compare is 5 and maximum is 20 workbooks at one time, Each workbook have one or more sheets in it.
2. I must be able to change the workbook names in the code you make.
3. Each name data bulk to appear as a separate table, The table on the Report page should look like the one in the FinalReport sample attached.
4. In the FinalReport sample page the last 3 columns for the WorkBook Name, Sheet Number, Line Number must be included .
5. I can only pay 20 euros for this project.
6. I need it today or tomorrow max.
Please contact me If you have any question.
Thanks
I am ready to carry out your project in the minimum price and in the shortest possible time and with the highest quality!
Relevant Skills and Experience
Microsoft Excel, vba
Proposed Milestones
€20 EUR - Project completed
Mayba later...
€20 EUR in 1 day
5.0 (111 reviews)
6.3
6.3
6 freelancers are bidding on average €20 EUR for this job
Will be delivered before dead line. send the task file
Relevant Skills and Experience
Macro
Proposed Milestones
€24 EUR - Macro
Can be easily done in macro