Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Help
Ok, this is new to me so this might not even be possible. Where is what i want to do. A1 will be a pick list pulled from another worksheet in the same file. The pick list will contain A, B, and C. B1 will give you another picklist depending on your answer for A1. If a1=a, show list de_a If a1=b, show list de_b If a1=c, show list de_c C1 will you you another picklist depending on your answer for A1. If a1=a, show list n_a If a1=b, show list n_b If a1=c, show list n_c Any ideas on how to do this, or does this not make any sense at all? Thanks in advance... -- a2fire2i ------------------------------------------------------------------------ a2fire2i's Profile: http://www.excelforum.com/member.php...o&userid=28813 View this thread: http://www.excelforum.com/showthread...hreadid=485049 |
#2
|
|||
|
|||
Excel Help
See:
http://www.contextures.com/xlDataVal02.html Hope this helps Rowan a2fire2i wrote: Ok, this is new to me so this might not even be possible. Where is what i want to do. A1 will be a pick list pulled from another worksheet in the same file. The pick list will contain A, B, and C. B1 will give you another picklist depending on your answer for A1. If a1=a, show list de_a If a1=b, show list de_b If a1=c, show list de_c C1 will you you another picklist depending on your answer for A1. If a1=a, show list n_a If a1=b, show list n_b If a1=c, show list n_c Any ideas on how to do this, or does this not make any sense at all? Thanks in advance... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |