Create a button that will find today's date in a spreadsheet.

[slindfors]

I would like to create a button that will find “today’s” date on my spreadsheet. The actual file is much longer, it covers 13 months, so being able to move directly to the current date would be helpful. In the example, A1 in the Tracker Tab is derived from the user’s input from the Limits Tab. Subsequent dates, A2 and below, are derived by adding 1 to the date above. If today were Dec 12th and I was looking at data from March, it would be helpful to press a button and have it scroll all the way back to 12 Dec 15.

[skywriter]

Try this.

Please Login or Register  to view this content.

[FDibbins]

Another - non-VBA - option would be to use teh HYPERLINK function...
=HYPERLINK("#"&"A"&MATCH(TODAY(),A:A,0),INDIRECT("A"&MATCH(TODAY(),A:A,0)))

This will show the contents of the cell containing the date. If you would prefer the cell ref to show instead...
=HYPERLINK("#"&"A"&MATCH(TODAY(),A:A,0),"A"&MATCH(TODAY(),A:A,0))

[slindfors]

Thank you both for the reply.

The code returned the "Today not found..." msg box. I'm still learning code so I don't know what the issue may be.

I tried the hyperlink option and it is successful, I think... I don't know how to implement that into a button so I put it in a cell. The cell thing did work. Is it possible to have "Today" displayed instead of blank or the matching cell? That would be great... or, can you provide instruction on how to implement your solution into a button?

Thanks again to both!

[FDibbins]

I don't know how to implement that into a button so I put it in a cell. The cell thing did work. Is it possible to have "Today" displayed instead of blank or the matching cell? That would be great... or, can you provide instruction on how to implement your solution into a button?

TYou dont need a button, just click the hyperlink in that cell.

If you just want TODAY shown, change to...
=HYPERLINK("#"&"A"&MATCH(TODAY(),A:A,0),"Today")

[skywriter]

The code returned the "Today not found..." msg box. I'm still learning code so I don't know what the issue may be.

My guess would be the workbook you are using it on is somehow different than that which you posted.
Date format perhaps.
My code looks at how the date in cell A1 is formatted, maybe your actual sheet doesn't have a date in A1?
I would have to see what the difference is.
It works with the workbook you posted.