Combine Worksheets to One new Sheet

G

Guest

I have a workbook w/ many worksheets (all randomly named w/ wierd sheet
names). All of the worksheets have the same structure w/ the same header row
except they vary by number of rows. I need a macro that would create a new
workbook w/ only one sheet containing all the data from all the worksheets in
one spreadsheet. Basically it would have to go from sheet to sheet copying
the data and pasting to the new document (only grabbing the header from the
first sheet.)

Your help would be greatly appreciated.

Thank you in advance.
 
G

Guest

Thank you - this did work but I first had to get over a 1004 runtime error.
Then I had a new issue because the amount of data exceeded the amount of rows
available in Excel XP. I have a new post out because I need to use a text
file now instead.

This was so helpful though - thank you so much!
 

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

Macro to combine worksheets 10
Combine three InputBoxes into one? 7
Combine multiple worksheets in one Workbook into one big worksheet 6
Combining Multilple Worksheets Into One 6
Combine All Worksheets into one 1
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
combine sheets from several workbooks into one 1
Concatentating Multiple Worksheets into One 15

Top