Union or Join Sheets

[Jeff C]

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.

 

[JE McGimpsey]

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

 

[Shane Devenshire]

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