DEPENDENT DROP DOWN LIST

S

SSJ

Hello everyone,

From "Contexture.com", I was able to learn how to create a one dependent drop down list.

However, I need to have 2 dependent list based on the first list.

1) My first list is of the department names
2) Each department has a list of capital expenditures, which I was able to name as the department name and was able to get my first dependent list.
3) But I need one more dependent list for the asset class.

As the names of the departments has already been used to create the first dependent list, I am not sure what to do to create the 2nd dependent list.

Shahid
 
D

Debra Dalgleish

If the first dropdown is in A2 and the second dropdown is in B2, the
data validation for cell C2 could be: =INDIRECT(A2 & B2)

For example, if A2 contains Finance, and B2 contains Computers, C2 would
show a dropdown based on a range named FinanceComputers.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Drop down lists in seperate columns 5
MS Project Center-Autolink column fields 0
Formating bolded text exclusively. 0
dependent, multiple variable, drop down list 2
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Need help modifying code 0

Top