Union or Join Sheets

J

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.
 
S

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
 
Top