Consolidating 10 differing worksheets by left column data

  • Thread starter Thread starter mcase
  • Start date Start date
M

mcase

Hello,

I recently went through my card collection and input the various card
I have. I have 10 boxes, each with their own worksheet within th
workbook. columns A1 through E1 have the following assingments: Card
Card Type, Quantity, Value, Set. I desire to consolidate th
worksheets into one, and want to be able to do it so that if a certai
card was in more than one box, the consolidation worksheet will hav
the Card, Card Type, TOTAL Quantity, Value, and Set correctly.

The thing to watch out for is that not all of the boxes contain th
same cards and therefore the cards are not in the same row across th
different worksheets.

I am new to this indepth type of use of excel and do not know how t
accomplish this. I have tried a couple of times with usin
data>consolidate, but dont know what I need to be putting as th
reference or how to put the reference correctly. Each time I hav
received a notice that 'reference data invalid'. I am using versio
2000.

Thank you
 
The simplest method I can think of is to create an
additional worksheet and copy all the data from the other
10 sheets in to the one.

Then, sort by Card (or Card Type). Depending on the
difference of the two, I think you'll see where I'm going.

Once sorted, you can use the Data|Subtotals feature.
For each change in CARD (or Card Type) subtotal the other
3 columns (Quantity, Value, and Set).

Hope that helps!
 
Back
Top