Help to copy the data from multiple Workbook to Single Workbook

[Sakthikumar Chinnasamy]

My scenario is I want to do dynamic consolidation of data from multiple workbooks to single workbook.

I have excel file called “Dynamic Consolidated” . In this file, there are two sheets. Sheet1 “Source file” & Sheet2 “Output”

“Source” Sheet – In this Sheet, in column “B”, I need to specify the path of files were I need to copy the data o this excel sheet.

“Output” Sheet – In column “A”, we need to type the column header which are available in the source files. If I type as “Employee code” in "A1" of Output sheet and run the macro. Macro need to copy the employee code from all the files which I specified in the source sheet and paste those data in output sheet of “Employee code” Column. If I will specify another header name in B1 of output sheet, macro need to copy those data and paste in respective column.

 

[AlanSidman]

When I look at David.xlsx it has two employee codes. What should your results look like in the Output Sheet for David and the others. A sample of the output would be really helpful to understand what you are looking for. Will you also be looking for other data? If yes, then would that go in a new column or replace the data for Employee Code. More information and an understanding of the business process is important to provide you with a solid solution.

 

[Deepak]

This might help you.

https://chandoo.org/forum/threads/merge-sheet1-from-multiple-workbook-using-single-connection.33746/

You may ask the author after understanding the concept for further help.