I am working on a daily inventory spreadsheet and want to make it where everything that has to be typed in each day is under the same tab. I have attached a smaller example of what im working on. I want to be able to enter the data daily under the input tab and for that data to transfer over to the other tabs. The biggest problem I have is that everytime I change the data in the input page, the old data is erased from the monthly totals. Is there any way to correct this?
Bookmarks