Dropdown with Selections to Other Sheets

[vincebk]

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.

 

[kweaver]

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]

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]

If the sheet names are the employee names, that's your list. Here's an example:

Book1
	A	B
1	Master	Johnson
2	Jones	Go to sheet
3	Weaver
4	Johnson
Master

Cell Formulas
Range	Formula
B2	B2	=HYPERLINK("#'" & B1 & "'!A1","Go to sheet")

Cells with Data Validation
Cell	Allow	Criteria
B1	List	=MySheets