I would like to create a summary page showing 3 months's data contained on a
second sheet in my Excel workbook.
The 3 month summary table should summarise:
All the Mon 8:15 data for the 3 tables
all the Tues 8:15 data for the 3 months etc etc.
Then all the Mon 8:30 data for the 3 months etc. etc
The column headings for January in Table 1 are:
Time Mon Tue Wed Thur Fri Sat
8:15 237 287 269 etc
8.30 123 456 etc
etc
The column headings for February in Table 2 are:
Time Mon Tue Wed Thur Fri Sat
8:15 269 197 262 etc
8:30 etc
The column headings for March in Table 3 are:
Time Mon Tue Wed Thur Fri Sat
8:15 186 291 267 256 etc
8.30 269 197 262 etc
What will be the easiest way to accomplish this? A pivot table? If so how do
I create one? A macro or visual basic script?
Many thanks!
Bookmarks