Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summary sheet ? pivot table?
I have a workbook with individual sheets that have invoice information for
each period on each sheet. I want to total the invoice in a quarter onto a summary sheet. I would like this total to expand or decrease automatically given the number of sheets entered in each period. I also which to collect the information on the amounts received from each customer for each invoice on this summary. what is an easy way to do this? Macro? Pivot table? =sum? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display Pivot table summary in order of increasing time frame | Excel Discussion (Misc queries) | |||
linking pivot table data to a cell in other sheet | Excel Worksheet Functions | |||
Pivot Table Refresh Deletes Range On Different Sheet | Excel Discussion (Misc queries) | |||
How do you unlock a pivot table on a protected excel sheet? | Excel Worksheet Functions | |||
Pivot Table Use When Sheet is Protected | Excel Discussion (Misc queries) |