lists dependent on preceding list selection
 

I want to make a pull-down list, but I want the list column B to be
dependent on what someone pulls down in column A. For example:


ANIMAL DESCRIPTION
dog terrier, sheperd, daschound, great dane
cat marbled, tabby, ferral
fish big, small, goldfish
horse racing, working, farm, cart


So, if someone pulls down "dog" in A, I only want the possible dog
descriptions displayed, and so on. I don't really know VBA programming,
but if that's the only way to do it, I'll learn. Just need some guidance
from those smarter excel folks.

Thanks!!


--
Weissme
------------------------------------------------------------------------
Weissme's Profile: http://www.excelforum.com/member.php...o&userid=34044
View this thread: http://www.excelforum.com/showthread...hreadid=570202

lists dependent on preceding list selection
 

Try Debra Dalgleish's page at:
http://www.contextures.com/xlDataVal02.html
Excel -- Data Validation -- Create Dependent Lists
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Weissme" wrote:

I want to make a pull-down list, but I want the list column B to be
dependent on what someone pulls down in column A. For example:


ANIMAL DESCRIPTION
dog terrier, sheperd, daschound, great dane
cat marbled, tabby, ferral
fish big, small, goldfish
horse racing, working, farm, cart


So, if someone pulls down "dog" in A, I only want the possible dog
descriptions displayed, and so on. I don't really know VBA programming,
but if that's the only way to do it, I'll learn. Just need some guidance
from those smarter excel folks.

Thanks!!


--
Weissme
------------------------------------------------------------------------
Weissme's Profile: http://www.excelforum.com/member.php...o&userid=34044
View this thread: http://www.excelforum.com/showthread...hreadid=570202