Dynamic Dropdowns

  • Thread starter Thread starter brownti
  • Start date Start date
B

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
 
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
Click to expand...
 
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)
Click to expand...

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
 
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
 
Back
Top