M
Mr L Hibbert
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???
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???