Good morning everyone.
I have a spreadsheet that records clocking in and out times and combined hours. Columns A-D are frozen. The next three columns are headed up by a date and contain Start time, end time and total hours.
Picture2.jpg
This format of three columns per day continues through to the end of the year, making it a really wide spreadsheet.
Is it possible to insert a button somewhere that when clicked moves the unfrozen columns to today's date so times recorded are entered into the correct day. So if I pressed it now, column E headed with today's date would sit next to D, press it tomorrow and column H would be next to D. Does this make sense?
Does this make sense?
Thank you!
Alan
Bookmarks