Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have twelve worksheets (one for each month of the year). On them are
customers and expenditure figures. Each sheet has some customers repeated and also some different ones. I want a thirteenth sheet that lists all the different customers from the year and shows their total expenditure for the year. I can then add some graphs and sort the accumulative data into 'top ten' and 'worst ten' customers etc. How do I create this thirteenth sheet with minimum manual labour? -- Thank you, Colin. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate accumulative total, based on conditions of two different | Excel Discussion (Misc queries) | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
Accumulative Chart? | Charts and Charting in Excel | |||
Want to have accumulative totals in each row | Excel Worksheet Functions | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions |