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
Debra Dalgleish - 25 Mar 2008 00:56 GMT
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.
> Hello everyone,
>
[quoted text clipped - 13 lines]
>
> Shahid

Signature
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html