I have a file that has 3 tabs. The first tab is an index and I'd like to put a hyperlink to another tab so clicking on a cell will take me to a specific cell in another tab. An example is tab INDEX and the other tabs TAB A and TAB B. Click on a cell in INDEX will take me to TAB B cell A12.
I've tried a number of ways to do this but can't make it work. Can someone help me accomplish this?
Hyperlink to worksheet tab
Re: Hyperlink to worksheet tab
Yes, you can use the Hyperlink function for that purpose. In the cell where you want to click in Index Tab to jump on Tab B, enter below function:
=HYPERLINK("[]Tab B!A12")
Thanks
=HYPERLINK("[]Tab B!A12")
Thanks