Multiple cell references in hyperlink to place in this document

[jeff_cp]

I'm trying to create a "source" link to multiple fields in another worksheet in the same spreadsheet. In the "Type the cell reference" field, I need to reference 3 different fields so when a user clicks the Source link, it takes them to the worksheet and selects the 3 fields. The 3 fields are in cells M5, N5 and P5. I can use M5:N5 and it selects two of the three but I can't get it to select P5.

Help .

Thanks!

 

[CA_Punit]

First Create a Named Range and select M5,N5 and P5. Now Name it.
The named ranges will get reflected below the "Type the Cell References" under defined named

 

[jeff_cp]

That's perfect! Thank you!!!

 

[CA_Punit]

You are welcome