Home |
Search |
Today's Posts |
#1
|
|||
|
|||
link drop down menu to info in worksheet
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. |
#2
|
|||
|
|||
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 "bob" wrote: 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. |
#3
|
|||
|
|||
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 he http://www.contextures.com/xlDataVal01.html bob wrote: 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. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link in worksheet | Excel Discussion (Misc queries) | |||
Why am I unable to link a cell in one worksheet to a cell in anot. | Excel Discussion (Misc queries) | |||
Can I link a cell to reflect a worksheet name? | Excel Discussion (Misc queries) | |||
Applying a formula to a drop menu choice | Excel Discussion (Misc queries) | |||
How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel |