Consolidating Worksheets

[john@matthewdavidevents.c]

I have a file with roughly a dozen worksheets, each formated exactly the same way (same column headings, same column formatting, etc.). My goal is to create a final worksheet that combines each of the twelve previous sheets. I don't mean consolidate the data (I have already done that, on a summary sheet). But rather, to acheive the same effect as cutting and pasting each of the individual worksheets' data into one long worksheet. (For what it's worth, here's why I'm asking this question: it's easier for me to work on the data when it's broken up into sections, but it's easier to present to a client as one long worksheet.)

[Yogi Anand]

On 2002-05-16 18:18, john@matthewdavidevents.com wrote:
I have a file with roughly a dozen worksheets, each formated exactly the same way (same column headings, same column formatting, etc.). My goal is to create a final worksheet that combines each of the twelve previous sheets. I don't mean consolidate the data (I have already done that, on a summary sheet). But rather, to acheive the same effect as cutting and pasting each of the individual worksheets' data into one long worksheet. (For what it's worth, here's why I'm asking this question: it's easier for me to work on the data when it's broken up into sections, but it's easier to present to a client as one long worksheet.)

You mentioned one long worksheet, how about considering one wide worksheet. This is how I have done it in the past -- for organizational ease, if I had one list(table) starting in cell A1, I would use the next one in cell AA1, and the next list(table) starting in cell AB1 ... so the method to this madness is that each list(table) is offset by 26 columns, and all the list(table) ranges will have the same corresponding row numbers.

Hope This Helps

Regards!