Thread
:
Compile all Worksheets in a Workbook in to a single Worksheet?
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Dave
Posts: n/a
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
Reply With Quote