Making a dynamic list?!

Hi

Is it possible to populate a list (drop down box in a cell) based on a selection from another list?

I.E. I have columns A and B (for ease of explanation). When I click on A1, I have a drop down list from which i can choose from over 100 options. I then want to choose from a list to populate B1. However, I want my options in B1 to be dependant on what I chose in A1.

Is this possible?

I have made the lists using the validation tool, populating it from differnet columns on the worksheet.


If this makes any sense, any help would be greatly appreciated

C

You may be able to use data|validation and dependent lists.

Debra Dalgleish knows how:
http://contextures.com/xlDataVal02.html

mayerc wrote:
>
> Hi
>
> Is it possible to populate a list (drop down box in a cell) based on a
> selection from another list?
>
> I.E. I have columns A and B (for ease of explanation). When I click on
> A1, I have a drop down list from which i can choose from over 100
> options. I then want to choose from a list to populate B1. However, I
> want my options in B1 to be dependant on what I chose in A1.
>
> Is this possible?
>
> I have made the lists using the validation tool, populating it from
> differnet columns on the worksheet.
>
> If this makes any sense, any help would be greatly appreciated
>
> C
>
> --
> mayerc
> ------------------------------------------------------------------------
> mayerc's Profile: http://www.excelforum.com/member.php...o&userid=35447
> View this thread: http://www.excelforum.com/showthread...hreadid=552244

--

Dave Peterson

an alternative method

http://www.xldynamic.com/source/xld.Dropdowns.html

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"mayerc" <[email protected]> wrote in
message news:[email protected]...
>
> Hi
>
> Is it possible to populate a list (drop down box in a cell) based on a
> selection from another list?
>
> I.E. I have columns A and B (for ease of explanation). When I click on
> A1, I have a drop down list from which i can choose from over 100
> options. I then want to choose from a list to populate B1. However, I
> want my options in B1 to be dependant on what I chose in A1.
>
> Is this possible?
>
> I have made the lists using the validation tool, populating it from
> differnet columns on the worksheet.
>
>
> If this makes any sense, any help would be greatly appreciated
>
> C
>
>
> --
> mayerc
> ------------------------------------------------------------------------
> mayerc's Profile:
http://www.excelforum.com/member.php...o&userid=35447
> View this thread: http://www.excelforum.com/showthread...hreadid=552244
>