Links from sheet 1 to other sheets

andrewca

New Member
Joined
Nov 30, 2005
Messages
2
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
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
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

Well-known Member
Joined
Jul 8, 2003
Messages
1,395
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

New Member
Joined
Nov 30, 2005
Messages
2
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,799
Messages
5,574,388
Members
412,590
Latest member
Velly
Top