Excel Help

[a2fire2i]

Ok, this is new to me so this might not even be possible. Where i
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..

 

[Rowan Drummond]

See:

http://www.contextures.com/xlDataVal02.html

Hope this helps
Rowan