link drop down menu to info in worksheet

[Guest]

want to create a drop down that shows information from other worksheets. ie
as i select A it will read the information on A from the worksheet2.

 

[Guest]

How about a 'list'? Position your cursor where you want it in worksheet 1.
Go to
Data, Validation, Settings, Allow and choose List. In Source, click on the
red square in the spreadsheet icon, go to worksheet 2 and select what you
want displayed in worksheet 1. Click on the red again, and OK. When your
cursor enters the cell in worksheet 1, a downarrow appears with the list you
linked to.

HTH,
Carole O

 

[Debra Dalgleish]

In the data validation dialog box, you can refer to a list on another
sheet, but you'll have to name the list. There are instructions here:

http://www.contextures.com/xlDataVal01.html