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).
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.
8 freelancers estão ofertando em média €22 para esse trabalho
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