Dynamic Dropdowns

[brownti]

I have found the site: http://www.xldynamic.com/source/xld.Dropdowns.html
I want to add another drop down but am having trouble. The example
workbook that i downloaded doesnt include three lists, but the instructions
for adding another drop down talk about list4. I dont have any idea where to
put in my information for my third list. Can someone point me in the right
direction? If possible just update the example workbook for dynamic drop
downs and i can just change the data to suit my needs. Thanks

 

[brownti via OfficeKB.com]

Can anyone help me at all? Please?

I have found the site: http://www.xldynamic.com/source/xld.Dropdowns.html
I want to add another drop down but am having trouble. The example
workbook that i downloaded doesnt include three lists, but the instructions
for adding another drop down talk about list4. I dont have any idea where to
put in my information for my third list. Can someone point me in the right
direction? If possible just update the example workbook for dynamic drop
downs and i can just change the data to suit my needs. Thanks

 

[L. Howard Kittle]

Hi brownti

If I understand...?

I have used this method to 'harbor' up to 29 drop down lists, (the limit of
the CHOOSE function)

Name your four lists, then Data > Validation > Allow > List > and in Source

=CHOOSE(MATCH(B2,A1:A4),Paper,Steel,Wood,Gravel)

Where B2 has a drop down to select from a list of the named ranges of Paper
to Gravel that are in A1:A4.

And where the Paper named range refers to: H1:H4, Steel refers to: J1:J4
etc.

If this is indigestible, you can send me a sample workbook with precise
details and I will take a stab at it.

HTH
Regards,
Howard

 

[L. Howard Kittle]

Maybe I should have looked at the link first. It is a VBA solution and that
may be the only one you are seeking. I offered a non VBA solution but may
not suit your needs.

Regards,
Howard

 

[Karthik Bhat - Bangalore]

Just Check the file in the following link.
Its dynamic and you can have as many lists as you want.
http://groups.google.co.in/group/ExcelFiles_India/browse_thread/thread/4cd5781972704eb4

Thx
Karthik
Bangalore

 

[Karthik Bhat - Bangalore]

Hi

Just Use the file in the following link. Its got dynamic lists and you
can add many validation lists

http://groups.google.co.in/group/ExcelFiles_India/browse_thread/thread/4cd5781972704eb4

Thx
Karthik
Bangalore