Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create 3 list boxes dependent on prior selections | Excel Discussion (Misc queries) | |||
data validation--multiple dependent list | Excel Discussion (Misc queries) | |||
How do I create a dependent list, to a current list? | Excel Discussion (Misc queries) | |||
Data Validation lists - entering value not in list | Excel Discussion (Misc queries) | |||
Can I compare 2 lists to combine duplicate entries in new list? | Excel Worksheet Functions |