Can excell automatically open in a specific cell based on the date

[Karl E]

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

 

[Snakehips]

@Karl E In basic form, something like below pasted into the code module for your sheet will do it if and when the sheet tab is selected.

Private Sub Worksheet_Activate()
Dim MyRow As Long
  If Day(Now) = 1 Then
    
    MyRow = Month(Now) * 1000
    
    Cells(MyRow, 2).Select
  
 End If

End Sub

Hope that. helps.