How do I branch to another sheet in the same file?

W

wf4bk

I have a file with multiple sheets. Depending on who uses the file, I want
them to be able to click on a button (or other object) and have it display
one of the other sheets. It seems like this should be simple but can't quite
figure it out. I really don't want ot get involved with writing macros.
Thank you for any help!
 
P

Pete_UK

Here's an example. Assume your sheets are all numbered consecutively,
i.e. Sheet1, Sheet2, Sheet3, Sheet4 etc, then in Sheet1 cell A1 you
enter a number. In B2 enter this formula:

=HYPERLINK("#Sheet"&A1&"!A1","jumpsheet")

This will display "jumpsheet" in cell B2, coloured blue and underlined
(just like a normal link) - if you click on this cell you will Jump to
A1 in the sheet whose number is entered in cell A1 of sheet1.

So, your one of your workers might enter 10 in A1, click the link and
jump to Sheet10, whereas another worker will enter 7, click the link
and jump to Sheet7. Is this something like what you wanted?

Pete
 
S

StompS

I used this formula and it told me it could not open the specified file
I changed the formula to read:
=HYPERLINK(B16&"!A1","Go To Stage:")
Where B16 (on the sheet where the formula was) is a list and the data is
each named after another sheet in the workbook. Where did I go wrong?

Thanks! You people have all been amazing in the last two days in helping me
get this far in my project! VERY MUCH appreciated!
 
P

Pete_UK

One thing to look out for in the hyperlink formula is if your sheet
names have spaces in them - you need to incorporate apostrophes around
the name of the sheet. I never have spaces in sheet names, preferring
to use the underscore instead.

Hope this helps.

Pete
 
Top