VBA hyperlink

[Russk68]

Hi All!
I would like to click on a cell in one sheet and hyperlink to a cell in another sheet based on the cell value.
Example:
Sheet 1 column A, is a range of dates. Sheet 2 column A, is also a range of unique dates in chronological order.
I would like to click on a date in Sheet 1 column A and hyperlink me to the same date in Sheet 2 column A.

Thank you!

 

[My Aswer Is This]

Try this:
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Click on any cell in column A of Sheet(1) and script will select same value in column A of Sheet(2)

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Modified  1/9/2019  12:53:03 AM  EST
If Target.Column <> 1 Or Target.Cells.CountLarge > 1 Or IsEmpty(Target) Then Exit Sub
Dim SearchRange As Range
Dim lastrow As Long
lastrow = Sheets(2).Cells(Rows.Count, "A").End(xlUp).Row
Set SearchRange = Sheets(2).Range("A1:A" & lastrow).Find(Target.Value)
If SearchRange Is Nothing Then MsgBox Target.Value & "  Not Found": Exit Sub
Application.Goto SearchRange

End Sub

 

[Russk68]

Thank you very much!!

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

Thank you very much!!