LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 86
Default Accumulative sheet data

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate accumulative total, based on conditions of two different PH@tic[_2_] Excel Discussion (Misc queries) 2 June 12th 09 08:44 PM
Duplicate sheet, autonumber sheet, record data on another sheet des-sa[_2_] Excel Worksheet Functions 0 May 8th 08 06:56 PM
Accumulative Chart? chew Charts and Charting in Excel 4 April 1st 06 08:04 PM
Want to have accumulative totals in each row Sherry Excel Worksheet Functions 8 December 30th 05 04:20 PM
pull data from sheet two, then fill in the data to sheet one (part Jim Excel Worksheet Functions 3 December 11th 04 04:51 AM


All times are GMT +1. The time now is 04:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"