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

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...