Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
option panes/ drop down lists
is it possible for me to make a drop down list /option pane on one sheet,
while getting the cells for the list from another sheet? my goal is to use that option pane as a tool to make match functions work with exact matches any help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
option panes/ drop down lists
You need to create a named range. Select the cells you want in your list,
then either input a name (no spaces, e.g. MyRange) into the block left of address bar, or use Insert - Name - Define to set your range. Now, on the sheet you want dropdown, Data - Validation - List. Source: =MyRange Voila! -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Derrick" wrote: is it possible for me to make a drop down list /option pane on one sheet, while getting the cells for the list from another sheet? my goal is to use that option pane as a tool to make match functions work with exact matches any help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
freeze panes not an option | Excel Worksheet Functions | |||
Drop down list & frozen panes | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
Excel should have a second 'Freeze Panes' option that works in re. | Excel Discussion (Misc queries) | |||
There is no freeze/unfreeze panes option in the windows menu | Excel Worksheet Functions |