Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivoting Several Sheets
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivoting Several Sheets
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 he 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. RJB wrote: 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? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivoting Several Sheets
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! "Debra Dalgleish" wrote: 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 he 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. RJB wrote: 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? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet formatting after pivoting | Excel Discussion (Misc queries) | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
Pivoting for the sake of look | Charts and Charting in Excel | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
Pivoting - Problem | Excel Worksheet Functions |