Excel Validation, 2 drop lists?? 1

[tigercrap]

Hello all,

I'm not sure if this is possible either in code or formatting, but I need A1 to be a drop list, then A2 to be a drop list but A2 will list items dependant on what is selected is A1.

ie. If "DS" is selected from the drop down in A1, then A2 will list DS1,DS2,DS3.
If "BS" is selected from the drop down in A1, then A2 will list BS1,BS2,BS3.

My problem seems similar to thread68-938971.

Thanks

 

[KenWright]

With step by step instructions

http://www.contextures.com/xlDataVal02.html

Regards
Ken...............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
---------------- Click here to help the tsunami victims ----------------

 

[tigercrap]

Hey Ken...Well i tried the VLookup that you had and it partly worked but i could not get it to list all the items i wanted in the second column. It would only show the value from the second column on that same row.

Is the expression you suggested supposed to be in the cell or as a validation source?

Thanks for all your help, I am in desperate need.
Tim

 

[KenWright]

Did you try downloading Debra's example workbook that contains the Depenedent list example.

At the top of the link I gave you is another link that says 'Sample spreadsheets'

Click on that and then it's about the 13th description down with a sample download you can take a look at.

Regards
Ken.............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
---------------- Click here to help the tsunami victims ----------------

 

[tigercrap]

THANK YOU SO MUCH!!! That really helped...exactly what i was looking for!

Thanks again!

 

[KenWright]

My pleasure

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
---------------- Click here to help the tsunami victims ----------------