Dropdown with Selections to Other Sheets

vincebk

New Member
Joined
Aug 25, 2020
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
SnipSnip.PNG


Instead of making multiple hyperlinks that will guide users to the selected sheets when clicked on, is it possible to create one drop down that has the sheet names in it and once clicked on, it will direct the user to the selected sheet? For example, the drop-down will have all the names from Katrina to Deon and if a person selects Katrina from the drop-down, it will send the user to Katrina's sheet. Also, it cannot be Active X because multiple users will be using the sheet at the same time, it will be pulled from OneDrive and I've had problems with the saving function when adding Active X controls to the document.
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

kweaver

Well-known Member
Joined
May 8, 2018
Messages
1,308
Office Version
  1. 365
  2. 2010
Suppose you have a list of valid sheets on a "master" sheet in the A column.

In the B1 you can create your drop-down. Then, in B2 use: =HYPERLINK("#'" & B1 & "'!A1","Go to sheet")

That should work. This link will take someone to the specified sheet, cell A1.
 

vincebk

New Member
Joined
Aug 25, 2020
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
Suppose you have a list of valid sheets on a "master" sheet in the A column.

In the B1 you can create your drop-down. Then, in B2 use: =HYPERLINK("#'" & B1 & "'!A1","Go to sheet")

That should work. This link will take someone to the specified sheet, cell A1.

Where in the code would I put the employee names?
 

kweaver

Well-known Member
Joined
May 8, 2018
Messages
1,308
Office Version
  1. 365
  2. 2010
If the sheet names are the employee names, that's your list. Here's an example:

Book1
AB
1MasterJohnson
2JonesGo to sheet
3Weaver
4Johnson
Master
Cell Formulas
RangeFormula
B2B2=HYPERLINK("#'" & B1 & "'!A1","Go to sheet")
Cells with Data Validation
CellAllowCriteria
B1List=MySheets
 

Watch MrExcel Video

Forum statistics

Threads
1,118,656
Messages
5,573,431
Members
412,529
Latest member
cTatch
Top