I've got a sheet, in which column "D" is just numbers, fed real-time by mulitple other sheets in the same workbook.
Is there a way so that at say 5am every day, it saves what is in column D to column E. Then the next day, it saves it to F, then G, and so on?
What it is, is an inventory checkout sheet for our bar at work. Each page is a different type of booze (whiskey, rum, vodka, etc) and they have a touchscreen on the register comp. So I built a bunch of sheets with buttons to keep track of all the bottles they get out of the storage room.
I plan on leaving this sheet open on the comp 24/7 if possible, and keep track of the bottles that are taken from storage. But at the same time, I'd need it to clear all the tally boxes for all the entries (about 100 boxes split up over 6 sheets)
is this possible? if need be, I can post the sheets, I think.. I'm new to the forums here.
Bookmarks