I have an excel spreadsheet I use for tracking tasks completed (it counts # of tasks performed per day or month and also the time it took to complete each task)
I set up my tracking spreadsheet making Row A1000-1999 January, A2000-2999 February, A3000-3999 March and so forth. Tasks are identified in columns b-h according to #.
So to get to the question I have. I always have 1000 entries possible per month. Sometimes when we go from end of a month to a new month (ex. Jan to Feb) I forget to start my entries for Feb at 2000 and I have to go back and copy/paste corrections. Is there a way to have the cursor automatically move to cell A2000 if it’s the first day of February or A3000 if it’s the first day of March.
I hope this makes sense. Any assistance would be greatly appreciated.
Sincerely
Karl
I set up my tracking spreadsheet making Row A1000-1999 January, A2000-2999 February, A3000-3999 March and so forth. Tasks are identified in columns b-h according to #.
So to get to the question I have. I always have 1000 entries possible per month. Sometimes when we go from end of a month to a new month (ex. Jan to Feb) I forget to start my entries for Feb at 2000 and I have to go back and copy/paste corrections. Is there a way to have the cursor automatically move to cell A2000 if it’s the first day of February or A3000 if it’s the first day of March.
I hope this makes sense. Any assistance would be greatly appreciated.
Sincerely
Karl