ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   look for sheet name in list and creat hyperlink to cell (https://www.excelbanter.com/excel-programming/361731-look-sheet-name-list-creat-hyperlink-cell.html)

Jax

look for sheet name in list and creat hyperlink to cell
 
I have a large Workbook with a hyperlink to a spreadsheet (same workbook)
with history on it. When you click the hyperlink it takes you to that sheet
R1,C1. In that sheet R1,C1 I would like to return to the cell from the
previous link. example I click on R55,C1 on the master sheet and it takes me
to sheet 71 R1,C1. I would like to click on this cell and return to the
master sheet R55,C1. This work book has 240 Link/sheets. Do I use a look up
for this?


All times are GMT +1. The time now is 12:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com