I have multiple identical worksheets with identical fields but each sheet
contains data for different time periods.

Is there a better way besides manually copy and pasting to a new sheet to
combine the data as you would similar to a union query?

Thanks in advance.
--
Jeff C
Live Well .. Be Happy In All You Do

Take a look at the Data/Consolidate method in XL Help.

In article ,
Jeff C wrote:

I have multiple identical worksheets with identical fields but each sheet
contains data for different time periods.

Is there a better way besides manually copy and pasting to a new sheet to
combine the data as you would similar to a union query?

Hi,

Data consolidate is an option if your data is numeric. Otherwise you can
consider a pivot table solution.

Let us know if Data Consolidate doesn't meet your needs.

Cheers,
Shane Devenshire

"Jeff C" wrote in message
...
I have multiple identical worksheets with identical fields but each sheet
contains data for different time periods.

Is there a better way besides manually copy and pasting to a new sheet to
combine the data as you would similar to a union query?

Thanks in advance.
--
Jeff C
Live Well .. Be Happy In All You Do