Hyperlink to cell where condition is true within a range

Diogenes

New Member
Joined
Apr 2, 2014
Messages
34
Hi all,

Been searching the interwebs for an answer to how I might hyperlink to a cell where an IF statement is true.

I have a worksheet with 100's of columns with dates in them and then on the row above the following formula =IF(BP4=TODAY(),"TODAY","").

When tomorrow it arrives BQ4 will obviously become the "TODAY" cell.

My question is how do I create a hyperlink or button way back in Cell A3 which takes you to whatever cell that currently equals "TODAY" in a range from D3:APJ3.

Any help would be appreciated.

Thanks,
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
something along the lines of

Dim c As Range, rng
Set rng = Range("f1:f20")
Range("a1").ClearContents

For Each c In rng
If c.Value = Date Then
Range("a1").Select

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Sheet1!" & c.Address, TextToDisplay:="Today"
End If
Next c
 

Watch MrExcel Video

Forum statistics

Threads
1,099,696
Messages
5,470,206
Members
406,685
Latest member
711excelhelp

This Week's Hot Topics

Top