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!
Help .
Thanks!