View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jax Jax is offline
external usenet poster
 
Posts: 8
Default 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?