On file open, automatically scroll to today's date

Hi Folks!

Not a programmer and need some help.

I have a local sports team (Penguins) schedule on Sheet1.

Row 1, A1:E1 are the column headers and I have freeze panes set so that row 1 is always visible when scrolling down the sheet.

Column A, A2:A135 are daily sequential dates.

What I would like to do is when the file is opened is to have the data for today's date to automatically "scroll" so that it is immediately below the frozen pane row 1 column headers.

Any help will be greatly appreciated.

Hi Tony,

Try this..

Please Login or Register  to view this content.

Application goto.xlsm

Hi, Tony,

code goes into ThisWoorkbook, I assumed starting date and addinng one to the date before for column A:

Please Login or Register  to view this content.

Ciao,
Holger

Thanks guys!

Both methods work as desired.

Reps to both of you!