Combining 7 Excel Files into 1

[zalik22]

Hi,

I have 7 Excel files in a folder called "Test" on my desktop and need to merge them into a single spreadsheet called "Combined Data". The data in each file has one spreadsheet, all the columns are the same, and the data starts on row 8. For all the files, I want the data to extract from Row 8, and copy until the end. The "Combined Data" file would have one spreadsheet from file1 row8-end, followed by file2 row8-end, etc.

Thanks in advance!

 

[navic]

....The code copied rows 1-8 7 times.

The VBA that @Fluff gave works for me. See image

 

[Fluff]

Columns A-X, row 8 to end of spreadsheet is what I want to copy. The code copied rows 1-8 7 times.

That doesn't answer my question.

 

[zalik22]

Sorry, realized the spreadsheet had a hidden tab. Changed the 1 to 2 and it worked perfectly. Thanks!

 

[Fluff]

Glad you sorted it & thanks for the feedback.