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

**Ignesh** · 04-25-2012, 04:01 AM

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.

**arlu1201** · 04-25-2012, 05:48 AM

Couple of questions -

Should the data from all the 3 sheets be consolidated into 1 sheet or 3 separate sheets?
What do you mean by based on selection of files, the data has to be copied?
Will there be any other files in the folder other than the ones to be copied?

Can you upload a sample of one of the files and also of the expected output file?

**Ignesh** · 05-01-2012, 03:11 AM

the data will be in two sheets, namely sheet1 & sheet2. The data from sheet1 & sheet 2 has to be consolidate to my "Consolidation" file. The data as is has to get cut & paste to consolidation to the appropriate sheets of 1 & 2. File names will vary and all files in a particular folder need to have the data moved to consolidation.