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?

Check out this link...

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

Jim Thomlinson


"cardosol" wrote:

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?

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

"Jim Thomlinson" wrote:

Check out this link...

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

Jim Thomlinson


"cardosol" wrote:

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?

On Apr 28, 11:56*am, cardosol
wrote:
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?

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

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.

"jlclyde" wrote:

On Apr 28, 11:56 am, cardosol
wrote:
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?

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

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

"cardosol" wrote:

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.

"jlclyde" wrote:

On Apr 28, 11:56 am, cardosol
wrote:
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?

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