View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
SSJ SSJ is offline
external usenet poster
 
Posts: 58
Default DEPENDENT DROP DOWN LIST

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