Pivoting Several Sheets

  • Thread starter Thread starter RJB
  • Start date Start date
R

RJB

I have sales information, where each account is an entire sheet.

I have added SUM totals on certain columns on each sheet (same relative
column, that is, column D is always "Sales", column E is always "Tonnes",
etc.).

I'd LIKE to do a summary sheet. What I've been doing is copying all data
from the individual sheets into a new worksheet, and pivoting that.

Is there an easier way to just "grab" what I want from the top row of each
sheet, automagically?
 
You can create a pivot table from the data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want.
There's more information here:

http://www.contextures.com/xlPivot08.html

Perhaps you could store all your data on one sheet permanently, instead
of copying it there just when you need a report. If you add a column
with the Account name, you could use an AutoFilter when you want to
focus on the records for one account.
 
Thanks. Part of my problem is I'm doing forensic work on other peoples'
files... So I'm stuck with what they have a legacy of doing!
 
Back
Top