Thomas Kuriakose
Active Member
Respected Sirs,
Compliments of the season.
We have a workbook, which has cities and points as in the attached file. The cities are in Index tab J3:J7. The points (G3:G20) are distributed in multiple sheet tabs.
Index tab:
a) Cell B3 has cities with data validation from list in J3:J7
b) Cells B4 down has the points matched based on the selected city in B3.
We need to have a hyperlink from the values in cells B4 down linked to the respective points sheets. I tried to use the hyperlink formula, but it does not work. I am not able to use the cell reference derived in cells B4 down to reference the sheet tab in hyperlink.
Kindly help with the below -
a) How to get the hyperlink without a helper column in cells B4 down.
b) How to use cell reference in friendly name syntax if possible as in formula C4 and D4
Thank you very much for kindly support and guidance always,
with regards,
thomas
Compliments of the season.
We have a workbook, which has cities and points as in the attached file. The cities are in Index tab J3:J7. The points (G3:G20) are distributed in multiple sheet tabs.
Index tab:
a) Cell B3 has cities with data validation from list in J3:J7
b) Cells B4 down has the points matched based on the selected city in B3.
We need to have a hyperlink from the values in cells B4 down linked to the respective points sheets. I tried to use the hyperlink formula, but it does not work. I am not able to use the cell reference derived in cells B4 down to reference the sheet tab in hyperlink.
Kindly help with the below -
a) How to get the hyperlink without a helper column in cells B4 down.
b) How to use cell reference in friendly name syntax if possible as in formula C4 and D4
Thank you very much for kindly support and guidance always,
with regards,
thomas