Merging two worksheets into one to create a pivot table

S

Scottie318

Hello,

I am currently doing a project at work which requires me to take tw
Inventory Activity Reports and merge them into one so my manager ca
use them to create a pivot table to show a month by month sale
breakdown. The common field that needs to be linked is the Product ID
I have an April sheet and a May sheet. How do I turn them into on
sheet and combine the data without me going line by line and doing so?
I simply want to merge the sheets so a pivot table can be created fro
the single sheet
 
D

Debra Dalgleish

If you don't have more than 65536 records, and the sheets are set up the
same, copy all the records from May, and paste them at the end of the
April records.

Then, create a pivot table from the combined data.
 
Top