copy & paste data from multiple workbooks to new workbook in a folder

[Ignesh]

Hi,

I am trying to have a vb code for copy & paste data from multiple worksheets to new work book called as "ConsolidatedDetails". All multiple workbooks has three sheets each and macros have to copy & paste data from all three sheets. If there is no data in any of the three sheets it should ignore and move to the next file. Since the data is copying from multiple workbooks, the macro should be able to identify the last row in consolidated details and have to continue from all the files.

The data varies in all workbooks and file names are not constant. Based on the selection of files, the data has to be copied. I am using excel 2003 and the folder path is c:\trial\filename.xls


please let me know how I can do this.​

 

[jbeaucaire]

'WORKBOOKS TO 1 SHEET STACKED
Here's a macro for collecting data from all files in a specific folder.

Workbooks to 1 Sheet​

The parts of the code that need to be edited are colored to draw your attention.

You will want to add in the optional code at the bottom of that page to collect data from multiple sheets.

 

[Ignesh]

yes it is working fine perfectly.

Where do I need to change if I need to copy the data from sheet1 to master1 and sheet 2 to master2. I am trying to trace it out but no luck in my favour.

 

[jbeaucaire]

'WORKBOOKS W/MULTIPLE SHEETS MERGED INTO SHEETS IN CONSOLIDATION WORKBOOK
Here's a macro for collecting data from all sheets in all files in a specific folder merging into matching sheets.

Workbooks to Sheets - Part 4​

The parts of the code that need to be edited are colored to draw your attention.

 

[Ignesh]

Thanks for helping me on this...your solution worked out in a very good way.

 

[jbeaucaire]

You're very welcome. Thanks for the feedback.