Hi all. I have a large spreadsheet with consecutive dates in column A, covering past and future dates. I want to set up a hyperlink to go directly to the row corresponding to today's date. I think I've asked about it before somewhere but cant seem to find it now. I have excel 2007.
Thanks as always. KK
Assuming dates start in cell A2.
Data Range
This formula entered in cell A1:
=HYPERLINK("#A"&MATCH(TODAY(),A2:A100,0)+1,"Go")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
If you have a lot of dates, it would help if you used Freeze Panes so that the top row is always visible even if you scroll down several screen's worth, so you can just click on the "Go" in A1 of Tony's solution to get to today's date.
Also, I'm sure you will appreciate that Tony's dates in his example are formatted to show mm/dd/yyyy, but even if you use a different format his formula in A1 will still work for you.
Merry Christmas.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks