View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Colin Colin is offline
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.