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
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
Bookmarks