I have two sheets. One sheet records daily and weekly data for hours etc. The Daily Data is displayed on another sheet where a running total will be stored where other calculations are to done from. The problem is that the original sheet where the data is entered has to be cleared every week to start again. Obviously when this Data is cleared it is removed from the second page as well. Is there a way to keep the data on page two even when page one is cleared.