Hi,
I have recieved some help on my two options for the below problem, I will outline my two options and then what I wish/need
Option 1:
Pull data from Hyperlinks
Using the code
"Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Sheet1.Select
Range("B27") = Evaluate("=" & Target.SubAddress)
End Sub"
I am able to pull the data I need from Sheet2!"cell reference" however as the book follows the hyperlink there is a jarring "stutter" for end users (not myself) that may be confusing.
I wish for this to run without the switching from "schedule" sheet to "Sheet2" whilst still achieving the desired results
Option 2:
Follow comments and pull data.
using the code
"
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
On Error GoTo errHand
If Target.Comment.Text <> "" Then
Range("B27") = Evaluate("=" & Target.Comment.Text)
End If
On Error GoTo 0
errHand:
End Sub"
Problem with this is the need to enter individual comments with the appropriate reference from Sheet2!. If there is a way to have the "FIA1f" from "General English" row with a comment for "Sheet2!B2" and then for "FIA2" from "General english" to fill with "Sheet2!C2" and so on. Any options for not having to enter individual comments?
I have attached workbooks for both the Hyperlinks and comments solution.
Bookmarks