Jump to a date (find a date) - Formual/Macro/ActiveX or Hyperlink

[SelinaR]

Please help - I've tried various options found online and nothing is working:

I have a large spreadsheet with a long date range from A:3 to A:900

what would be the best way to jump to today's date?
I have seen formulas, Macro's, Active X controls, Hyperlinks?

I would prefere a Macro if possible.

THANKS

 

[puru.sve]

I've tried your new forumla but it's giving me the same error - how do I declare the variable please?

Sorry .. Its my bad ...


Dim i, r As Integer this line should be like Dim i, lr As Integer</pre>

 

[SelinaR]

Hiya

done the edit, but upfortunaltely still giving me the same COMPILE ERROR. thansk fo ryou help with this - the hyperlink formula works a dream.... I just have to come to terms with the fact that it can't be done

thanks for all your efforts.

it's very much appreciated!

 

[puru.sve]

Send me your file on puru.sve@gmail.com .. Let me check why this is not working .. it must work

 

[safarihospitality]

You may try this :


=HYPERLINK("#"& "A" & MATCH(TODAY(),A3:A900,0)+2,TEXT(TODAY(),"m/dd/yyyy"))

I'm trying to use this same idea but for a range that is across columns instead of down rows. Could you help me with a hyperlink that does the same thing only the range is D2:AH2 instead of A3:A900?

 

[puru.sve]

Hi ,

here you go ...

=HYPERLINK("#"& ADDRESS(2,MATCH(TODAY(),D2:AH2,0)+3),TEXT(TODAY(),"m/dd/yyyy"))

 

[SelinaR]

Thanks so much to you PURU.SVE..... you have worked tierelessly onl my issue until you resolved it for me!

thanks so very much - your a legend!

Have a gerat weekend!

 

[puru.sve]

Thanks so much to you PURU.SVE..... you have worked tierelessly onl my issue until you resolved it for me!

thanks so very much - your a legend!

Have a gerat weekend!

Thanks for Feedback Selina.... We are here to help each other