Home |
Search |
Today's Posts |
#1
|
|||
|
|||
link to result from drop down list
How can I show the choice from a drop down list in one worksheet in a specific cell in another worksheet? Any suggestions? Thanks. -- dcruickshank |
#2
|
|||
|
|||
Dcruickshank wrote:
How can I show the choice from a drop down list in one worksheet in a specific cell in another worksheet? Is the dropdown from the Forms toolbar or from the Control Toolbox? If the former, use Format / Control / Cell Link to specify a linked cell which will contain the index into the list. Then the formula =INDEX(TheList, TheLinkedCell) will give you the selected item If the latter, name the cell you want to contain the choice and enter that name against LinkedCell in the Properties window. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
I am trying to link based on a text value instead of cell position | Links and Linking in Excel |