Hyperlink to Sheet finding data & highlighting

[zeroride]

Hello Experts!

This is my first post so please have patience.

I'm trying to figure out how to use the hyperlink in Excel which takes me to a separate sheet in the workbook, searches for a value and then highlights the row.

Example:
Sheet1 M2 has 12345 in it
Sheet2 G15 has 12345 in it but if you filter on column G, this changes to G56

How can I hyperlink to Sheet2, locate 12345 in column G and then highlight the row?

Thanks in advance!
Zeroride

 

[zeroride]

I think I figured out part of it by using:

=IF(ISNA(VLOOKUP(B2,RSA!$A$2:$G$256,7,0)),"",HYPERLINK(VLOOKUP(B2,RSA!$A$2:$G$256,7,0),VLOOKUP(B2,RSA!$A$2:$G$256,7,0)))

but getting a CANNOT OPEN THE SPECIFIED FILE error so it is not jumping to my second sheet.

HELP!

Hello Experts!

This is my first post so please have patience.

I'm trying to figure out how to use the hyperlink in Excel which takes me to a separate sheet in the workbook, searches for a value and then highlights the row.

Example:
Sheet1 M2 has 12345 in it
Sheet2 G15 has 12345 in it but if you filter on column G, this changes to G56

How can I hyperlink to Sheet2, locate 12345 in column G and then highlight the row?

Thanks in advance!
Zeroride