Obtain data from list

D

dipsy

I want to get the data from the list on to a cell in
worksheet.

I have 2 sheets - On Sheet 1 - I have drop downs.
Whatever is selected in the list - I want to show that
value in a cell on Sheet 2.

Any help is greatly appreciated.

Thanks!
 
J

jeff

Hi,

I think if you just change the properties of your dropdown
so that the linked cell refers to the cell on your other
sheet, it should work fine. Right-click on the dropdown
and goto properties...Linkedcell.

jeff
 
G

Gord Dibben

dipsy

In the cell on Sheet2 enter =Sheet1!cellref

Where cellref is the cell with the drop-down value choice.

Gord Dibben Excel MVP
 
Top