Combine Worksheets into One

[lhaley]

Is this a way to combine multiple worksheets into one main worksheet if all the columns headers are the same?

[Skip Bisconer]

Define your process a little better. If all you want is a total worksheet for all the other sheets its one thing. If you want take all the data out of the other sheets and put into one its something else.

Skip Bisconer

[ This Message was edited by: Skip Bisconer on 2003-02-02 18:00 ]

[Skip Bisconer]

Define your process a little better. If all you want is a total worksheet for all the other sheets its one thing. If you want take all the data out of the other sheets and put into one its something else.

Skip Bisconer

[lhaley]

I have a workbook that contains 6 sheets. I would like to take the information that is on each of those 6 sheets and combine them into one sheet. It could be either creating a new workbook or within the existing one.

All of the sheets have the same headers and formats.