You will need to use named ranges and the INDIRECT function to do the dependent validation list.
Here's a detailed guide on how to do it:
http://www.contextures.com/xlDataVal02.html
SOURCE: Drop Down Menus
Click on Data (Top menu), Choose Filter from the drop down list, Choose
Auto filter from the shown list. Now you get filter list on each
column. Choose the filter condition on the column(s) you want and the
data get filtered based on the condition you have given.
Fixya?
SOURCE: DropDown menus in Excel
The quickest and easiest way is to go to the data menu and choose filter and then autofilter. This will allow drop downs on all columns which can be picked to filter one or more columns. Custom in the drop down list will give you further options.
SOURCE: Excel
Would you not be better off with a pivot table ?
To use multiple drop downs - each listing would need to be associated, or have a column that causes a relationship.
When selection 1 is made - a formula will dictate what fields to make visible (available) in the next menu..
you could build a macro in that will 'lift' the formulised data, and 'paste as values' it into a control area that will then give you a definitve second list based purely on the initial drop down.
Hope this makes sense
SOURCE: using drop-down form field in a word 2007 template
You need to protect the form (Protect Document, Editing Restrictions (Filling in Forms) then Start Enforcing Protection, the drop down menu will then work.
|
|
|
72 views
Usually answered in minutes!
×