View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mr L Hibbert Mr L Hibbert is offline
external usenet poster
 
Posts: 5
Default summaries on alternative sheets

hello im trying to compile a small folder consisting of different worksheets,

each worksheet is a different customers sales etc.... with totals for JAN,
FEB etc throught to the year,

these totals for each customer month are to be summarised in a summary
spreadsheet,

how do i extract the data from the customer folder to the summary box.

at the moment i can only a = formula, but copy and paste does not allow the
boxes to use the formula for all the sheets, this is hard to explain

For example

A - summary
B - customer 1, detailed sales for jan, feb, mar, etc.. with totals of each
month
C - customer 2
D - customer 3
E - customer 4

The A -summary spreadsheet get each total of month for each customer to
represent total monthly sales. i have by units and figures.

Can anybody share some wisdom on excel???


--
L Hibbert