Hi I have a workbook of which has 13 sheets and I want to keep a running total for all sheets.
Ive been looking on internet and believe it a pivot table. Don't know where to start as not that far advanced. Let me explain what I need to do.
In sheets 1-13 the layout will be the same as in column headings etc.
in the sheet called "report" I need it to show a running total in the columns as follows..
If in sheets 1-13 in column B shows the word "CUBIC" , "SHERE" "CLB" "UNDER £1" I need the data from columns B,C,D,F carried over into a running total on the sheet called report.
If in sheets 1-13 in column B it does not show the words as shown above I need the data from columns B & F copied over into a running total in the sheet called report.
If it means doing it in 2 separate tables that's OK as long as they are both on the sheet called report.
Please find enclosed copy of worksheet.