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

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

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
>

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
>

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

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