If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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. |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Drop down list seliton filters | David | New Users | 5 | December 27th, 2004 12:39 AM |
Amount or Numbers in Words | ron | New Users | 9 | December 24th, 2004 07:32 PM |
how do i narrow down the items in a pivot table drop down list? | bac9999 | Charts and Charting | 1 | November 11th, 2004 03:33 PM |
Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
Readding Numerical value to ext | Hoang Han | Worksheet Functions | 2 | December 4th, 2003 05:37 PM |