-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Hyperlinks or Drop down list to select sheet name
- Thread starter howard
- Start date
Eric W
MrExcel MVP
- Joined
- Aug 18, 2015
- Messages
- 13,004
Hyperlinks is easy enough. Put this formula in A1:
=HYPERLINK("#Sheet2!A1")
The # is a shortcut meaning "this workbook". If you want a hyperlink to another workbook, you'd need to put the full path/file name in. You should be able to see how to change that to point to other sheets. So you could have 10 hyperlinks to 10 sheets.
If you don't want that many, you could set up a drop down menu. Using Data Validation, set up a rule with a list of all your sheet names. Put it in B1 (for example). Then in C1 you could have this formula:
=HYPERLINK("#"&B1&"!A1","Go!")
Selecting the dropdown would allow you to pick the sheet, then click on the hyperlink to go there.
Hope this helps!
=HYPERLINK("#Sheet2!A1")
The # is a shortcut meaning "this workbook". If you want a hyperlink to another workbook, you'd need to put the full path/file name in. You should be able to see how to change that to point to other sheets. So you could have 10 hyperlinks to 10 sheets.
If you don't want that many, you could set up a drop down menu. Using Data Validation, set up a rule with a list of all your sheet names. Put it in B1 (for example). Then in C1 you could have this formula:
=HYPERLINK("#"&B1&"!A1","Go!")
Selecting the dropdown would allow you to pick the sheet, then click on the hyperlink to go there.
Hope this helps!
Upvote
0
Similar threads
- Question
- Question
