Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compile all Worksheets in a Workbook in to a single Worksheet?
Is there any way to compile all of the Worksheets in the same Workbook in to
a single Worksheet? All of the header fields are labeled identically, Only the data is different. Think of it as each Worksheet contains a different chapter of a book. I want to consolidate all of the chapters into one Worksheet. Thank you very much for your help. Eric |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compile all Worksheets in a Workbook in to a single Worksheet?
Eric
Check out Data - Consolodate. I've never used it but it sounds like what you are after. Dave "Eric at MTI in Utah" <Eric at MTI in wrote in message ... Is there any way to compile all of the Worksheets in the same Workbook in to a single Worksheet? All of the header fields are labeled identically, Only the data is different. Think of it as each Worksheet contains a different chapter of a book. I want to consolidate all of the chapters into one Worksheet. Thank you very much for your help. Eric |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compile all Worksheets in a Workbook in to a single Worksheet?
With code try
http://www.rondebruin.nl/copy2.htm -- Regards Ron De Bruin http://www.rondebruin.nl "Eric at MTI in Utah" <Eric at MTI in wrote in message ... Is there any way to compile all of the Worksheets in the same Workbook in to a single Worksheet? All of the header fields are labeled identically, Only the data is different. Think of it as each Worksheet contains a different chapter of a book. I want to consolidate all of the chapters into one Worksheet. Thank you very much for your help. Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting a Single Worksheet froma Mutipage Workbook | Excel Discussion (Misc queries) | |||
Some worksheets not viewable within a workbook on a particular PC | Excel Discussion (Misc queries) | |||
Need to have multiple worksheets use a single worksheet | Excel Worksheet Functions | |||
grand total column B from every worksheet in workbook | Excel Discussion (Misc queries) | |||
Copying Totals of separate worksheets to a single Summary Worksheet | Excel Discussion (Misc queries) |