Drop Down List

  • Thread starter Thread starter bgideon
  • Start date Start date
B

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!!!
 
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
 
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
 
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 (" ' !)
 
Back
Top