Drop Down List

[bgideon]

In cell A1 on Sheet 1 I have a drop down box with a list
of names. Each name refers to another sheet in the
workbook (i.e. sheet 5 has information on "Bill"). How
can I make Sheet 1 show the information on Bill when his
name is selected from the dropdown box. And then if I
were to select "Jane" from the drowpdown box, show her
information on sheet 1. A mix of hyperlinks and freezing
panes? Please Help!!!

 

[Frank Kabel]

Hi
how are your sheets named? Are they named like the person's name?. If
yes you may use INDIRECT for this. Otherwise you may explain how you
know which sheet is associated to a person

 

[Guest]

yes, each sheet is a persons name, however, I do not know
how to use INDIRECT.

 

[L. Howard Kittle]

Hi bgideon,

Copy and paste into the sheet module. Assumes the sheet names are in a drop
down in D1 and each sheet is named after a person in the list.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target <> Range("D1") Then Exit Sub
Dim i As String
i = Range("D1").Value
Sheets(i).Select
End Sub

HTH
Regards,
Howard

 

[Frank Kabel]

Hi
to give you an example:
A1 stores yopur dropdown-list
B1 should get a value from the corresponding 'name' sheet (lets say you
want to see cell D3)
Use the following formula in B1
=INDIRECT("'" & A1 & "'!D3")
note the multiple apostrophes at the beginning (" ' ") and in the
middle (" ' !)