Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Multilpe Lists in Excel 2000
I have a client who wants to be able to pick an item from one list and then,
based on that result, have a second list become available in an adjacent cell. For example, if the colours "red, green and blue" are in the first list in cell C5, when selecting "red", a list containing "bunny, dog and cat should" appear in cell D5. If the colour "green" was selected in cell C5 then a different list, e.g.; "elephant, giraffe, lion" would appear for use in cell D5, and so on. Is this possible and if so, how would one accomplish it. Thank you, -- LPS |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Multilpe Lists in Excel 2000
You could use a couple of cells with data|validation and a couple of range
names. Debra Dalgleish explains it: http://www.contextures.com/xlDataVal02.html LPS wrote: I have a client who wants to be able to pick an item from one list and then, based on that result, have a second list become available in an adjacent cell. For example, if the colours "red, green and blue" are in the first list in cell C5, when selecting "red", a list containing "bunny, dog and cat should" appear in cell D5. If the colour "green" was selected in cell C5 then a different list, e.g.; "elephant, giraffe, lion" would appear for use in cell D5, and so on. Is this possible and if so, how would one accomplish it. Thank you, -- LPS -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Multilpe Lists in Excel 2000
Debra Dalgleish's site explains what you need to know:
http://www.contextures.com/xlDataVal02.html Does that help? €¢€¢€¢€¢€¢€¢€¢€¢€¢€¢ Regards, Ron "LPS" wrote: I have a client who wants to be able to pick an item from one list and then, based on that result, have a second list become available in an adjacent cell. For example, if the colours "red, green and blue" are in the first list in cell C5, when selecting "red", a list containing "bunny, dog and cat should" appear in cell D5. If the colour "green" was selected in cell C5 then a different list, e.g.; "elephant, giraffe, lion" would appear for use in cell D5, and so on. Is this possible and if so, how would one accomplish it. Thank you, -- LPS |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Multilpe Lists in Excel 2000
Yes, that was a fantastic tip!
Thank you. -- LPS "Ron Coderre" wrote: Debra Dalgleish's site explains what you need to know: http://www.contextures.com/xlDataVal02.html Does that help? €¢€¢€¢€¢€¢€¢€¢€¢€¢€¢ Regards, Ron "LPS" wrote: I have a client who wants to be able to pick an item from one list and then, based on that result, have a second list become available in an adjacent cell. For example, if the colours "red, green and blue" are in the first list in cell C5, when selecting "red", a list containing "bunny, dog and cat should" appear in cell D5. If the colour "green" was selected in cell C5 then a different list, e.g.; "elephant, giraffe, lion" would appear for use in cell D5, and so on. Is this possible and if so, how would one accomplish it. Thank you, -- LPS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activate method of Worksheet class fails in Excel 2000 | Excel Discussion (Misc queries) | |||
Can I lock info in Excel 2003 and users in Excel 2000 enter info? | Excel Discussion (Misc queries) | |||
Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel | |||
Setting tab colours on Excel spreadsheets (for Excel 2000) | Excel Discussion (Misc queries) | |||
Excel XP 2002 Vs. Excel 2000 | Excel Discussion (Misc queries) |