Conditional Lists

[cardosol]

Hi,

I have a spreadsheet where I am tracking expenses. I have several
catagories of expenses, like Telephone, Utlities, etc. I want to create two
lists, one for the type of expense and the other for the vendor of the
expense. How can I create the second list to populate based on the first list
selection.

For example, if I am doing a list for telephone vendors, I select my first
list to Say Telephone and the second list to populate Verizon, AT&T, Qwest,
Sprint or if I am doing it for utlities for my first list to populate
Utlities and the second list to populate Power, Water, Trash?

 

[Jim Thomlinson]

Check out this link...

http://www.xldynamic.com/source/xld.Dropdowns.html

 

[cardosol]

Is it possible for the data in the list to be reported against with this
option?

 

[jlclyde]

Hi,

I have a spreadsheet where I am tracking expenses.  I have several
catagories of expenses, like Telephone, Utlities, etc.  I want to createtwo
lists, one for the type of expense and the other for the vendor of the
expense. How can I create the second list to populate based on the first list
selection.

For example, if I am doing a list for telephone vendors, I select my first
list to Say Telephone and the second list to populate Verizon, AT&T, Qwest,
Sprint or if I am doing it for utlities for my first list to populate
Utlities and the second list to populate Power, Water, Trash?

Go to data/validation\ select list. then in the source range just
write an IF statment. If(X = telephone , then chose this list, if not
then chose another list or write another if statement. If you write
where the information is found, someone could help you write it.

Jay

 

[cardosol]

How do I copy the validation to another range of cells. when I do a copy
paste special, the formula does not work right, it references the cells
above.

 

[cardosol]

Nevermind, I got it to work. Thanks for everyones help.