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

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" wrote in
message ...

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