At work, we have sales tickets that are entered into spreadsheets. There is an excel file for each month and different worksheets for each day. Each worksheet is labeled with the correct date & day (in the worksheet itself and on the worksheet tab at the bottom). When a new year comes due, a blank spreadsheet is required that has the correct dates. Is there a way to quickly change the days and dates, in the worksheet and on the tabs, without having to re-type them all? Thanks.
Bookmarks