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? |
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? |
All times are GMT +1. The time now is 11:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com