Comparing contents of 2 sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have 2 sheets, one for 2002 and one for 2003. They contain products and quantities sold and I want to be able to compare how my sales are doing on sheet 3. In 2002 I sold 50 different types of products but in 2003 i have expanded my range to over 100, so I cannot just do a compare of them on sheet 3. I heard that you can use pivot tables etc. but how? Can someone please explain basically what i have to do. Heres a small sample

2002
Product qty
Shoes 10
bag 4
jumpers 6


2003
Product qty
shoes 16
Shirts 40
jumpers 10
hats 5
bags 2


is there anyway i could put a sample xl page here?

Thanks in advance
dave
 
I'd create a third sheet.

I'd copy the data (columns A&B) from the first sheet into the new sheet. In
column C, I'd put 2002 (all the way down the data).

Then paste the data (no headers this time) from 2003 to the bottom of that
range. And put 2003 in C for those values.

A quick way to put the year in is to select the range (say C2:C999), type 2002
and hit ctrl-enter. All those cells will be populated.

Now make sure you have a header row in A1:C1.
Product, qty, Year

Now select this whole range.

Data|pivottable
follow the wizard until you get to a dialog with a "layout" button on it.
click that button!

Drag the product box to the row field
drag the year box to the Column field
drag the qty box to the data field
(if it doesn't say "Sum of qty", double click on it and choose Sum.)

Finish up that wizard.
 
Back
Top