Too much data?

  • Thread starter Thread starter TRYIN
  • Start date Start date
T

TRYIN

I have 12 months of dealers information on 12 seperate tabs with 14 columns
for each dealer. I would like to create a master list where serching by
dealer number will add each column for each month.

I've tried adding vlookups for each sheet and gave me problems.
 
The cleanest thing to do is probably put all of you data on ONE sheet
(sorry, I'm a database purist) with a few blank rows above where the
data labels are.
Then use Data/Filter/Autofilter to turn on filtering so you can view
the portion you want results on.
Lastly, add SUBTOTAL (Subtotal will only calculate with the displayed
data after filtering) functions above any columns that you may want to
calculate.

=SUBTOTAL(func,range)
for the func value, 1=average, 2=count, 3=counta, 4=max, 5=min (and
there are others)
set the range as long as you like (I usually make it double the number
I rows I think I'll need)
 
Back
Top