Combine contents of multiple workbooks into one worksheet

G

Guest

I want to aggregate data from multiple workbooks into one. I have five
workbooks with identical columns and formats, and want to run a macro in a
separate workbook that copies all rows (starting with row#2 and ending at the
last row with data) from the five workbooks and pastes it all into the new
one. Or something like that. Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copying Worksheets From Different Workbooks using Marco 4
Pulling/Collating Data from Workbooks 6
Copy worksheet from one workbook to a master workbook 2
How do I combine five Excel 2003 workbooks? 2
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
combine multiple workbooks? overcome 255 character limit? 3
Copying Data from Multiple Sheets to One sheet 1

Top