Hi, just wondering if something was possible. I have a table set out like a timetable, with the date going across the top and time going down the side e.g.

image.jpg

The way that data is set is through another sheet, and in the table, I have the following type formula in each cell
Please Login or Register  to view this content.
tblData is the table where all the data is inserted. This is done in the following format
image2.jpg

As you can see, I have 2 buttons which add or remove a week from the dates. This updates the timetable for me for the following or previous weeks. Say if I press Forward One Week, at the moment, it removes all the data from the previous weeks and sets it to the new week I asked it to. I was wondering if there was a way to keep the data in the old week though, so if I press Forward One Week, I would have the data set for the two weeks?

Thanks