Yes it is possible. Do you have a header row for your data in Sheet1, so the actual data starts in row 2 ? If not I would suggest you insert a new row 1 and put appropriate header descriptions in the cells, and if you have them there you can put this formula in G2 of Sheet1:
and then copy this down to beyond your data to allow for future expansion - the hyphens will help to show you how far you have copied it.
Then put your headers in row 2 of Sheet2, and put this formula in A3 of Sheet2:
and put this formula in B3:
The formula in B3 can then be copied across into C3:F3, and then each cell formatted appropriately. Then you can copy the row of formulae from row 3 down into row 4 downwards as far as you think you need.
Then you can just change the dates in A1 and B1 to get another set of data displayed.
Hope this helps.
Pete
Bookmarks