A
Adam
Afternoon,
I have a spreadsheet which contains 8 sheets, the same
layout however for different customers as describe in the
sheet tab title.
I want to create a pivot table which source's all of
these 8 pages so it has the Sheet title in the Row, the
Date etc in the column and then Sum of cost as the data.
Anyone know a way of doing the above, I know I can if I
copy and paste all sheets into one sheet and pivot from
that but I thought there would be a more efficient way of
doing this.
Many Thanks
Adam
I have a spreadsheet which contains 8 sheets, the same
layout however for different customers as describe in the
sheet tab title.
I want to create a pivot table which source's all of
these 8 pages so it has the Sheet title in the Row, the
Date etc in the column and then Sum of cost as the data.
Anyone know a way of doing the above, I know I can if I
copy and paste all sheets into one sheet and pivot from
that but I thought there would be a more efficient way of
doing this.
Many Thanks
Adam