How can you open a tab(Sheet5) by clicking on particular cell say.
 

I made index on sheet 1. If my cell a2 has text INFO and my shhet 5 has the
details of INFO, what do I need to program so when I click on A2, it opens up
sheet 5 as soon as the clicking is done? Also as an alternate, I can store
iINFO details starting on cell b62. Can you go to b62 by clicking on a2?

How can you open a tab(Sheet5) by clicking on particular cell say.
 

So want when someone clicks on cell A2, that it will take the user to
Sheet5 Cell B62?

How can you open a tab(Sheet5) by clicking on particular cell
 

"Chip" wrote:

So want when someone clicks on cell A2, that it will take the user to
Sheet5 Cell B62?

Actually sheet 5 cell a1 or shhet 1, cell b62

How can you open a tab(Sheet5) by clicking on particular cell say.
 

Instead of writing code it would be easier to insert a hyperlink to the
required location