Links from sheet 1 to other sheets

[andrewca]

I have a workbook set up with multiple sheets which link to 'sheet 1', which is my 'cover sheet'

Can I install a 'button' or 'reference' point in sheet 1 that will take me straight to the specific sheet without having to scroll manually and open it??

Cheers

Andrew

 

[acw]

Andrew

Some options:
1) have a hyperlink
2) Formula reference to the child sheet then double click the cell.
3) Button (or some other control / icon) that can be coded to take you to a specific sheet / cell.


HTH

Tony

 

[babycody]

Hyperlinks are a great way to go. Here is a trick you may not know though. To the left of your sheet tabs you will see four small arrows. Try right clicking on them. Neat huh! Great if you have a large amount of sheets in a workbook.

 

[andrewca]

Thanks folks. Didn't know about the right mouse click so that will do the trick for me. Have not tried using hyperlinks so may experiment with that for future problems. Any tips on hyperlinks welcomed.