| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combine Worksheets to One new Sheet
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combine Worksheets to One new Sheet
Hi NYSA-HD
Start here http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "NYSA-HD" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combine Worksheets to One new Sheet
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! "Ron de Bruin" wrote: Hi NYSA-HD Start here http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "NYSA-HD" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I combine worksheets w/o enough rows to combine? | Excel Worksheet Functions | |||
| how do I combine identicle worksheets into one sheet | Excel Discussion (Misc queries) | |||
| In Excel combine tables from multiple worksheets in to one sheet? | Excel Worksheet Functions | |||
| how do you combine worksheets | Excel Programming | |||
| Combine All Worksheets into one | Excel Programming | |||
Linear Mode
