Dynamic Dropdowns
 

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200703/1

Dynamic Dropdowns
 

Can anyone help me at all? Please?



brownti wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200703/1

Dynamic Dropdowns
 

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

"brownti" <u31540@uwe wrote in message news:6f1428c9f3cb8@uwe...
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200703/1

Dynamic Dropdowns
 

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

"brownti" <u31540@uwe wrote in message news:6f1428c9f3cb8@uwe...
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200703/1

Dynamic Dropdowns
 

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/Exc...d5781972704eb4

Thx
Karthik
Bangalore

Dynamic Dropdowns
 

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/Exc...d5781972704eb4

Thx
Karthik
Bangalore