Creating Dependent lists
 

I have 2 lists that have options (Pump, Seal, Motor) & (1, 2, 3) that are
pulled from columns in another sheet made by Data Validation option. If I
select Pump on the first list and 2 on the second list I would like a list
(say a, b c) to be pulled from another worksheet on the next cell. But if I
select a different seneario with List 1 & 2, List three pulls a different
list.

another example:
List 1: Seal
List 2: 3
List 3: (12, 13, 14)List

List 1: Motor
List 2: 3
List 3: (aa, bb,cc)List

I understand this will probably take some VB code. I am hoping to find some
good example or if someone has some strands of code with some events, ifs,
ands, thens statements that do this I can modify it to my sheet.

Any sugguestions are welcome.
Thanks in advance.

Creating Dependent lists
 

hi
see this site. i think that is what you are look for.
http://www.contextures.com/xlDataVal02.html

regards
FSt1

"Alex H" wrote:

I have 2 lists that have options (Pump, Seal, Motor) & (1, 2, 3) that are
pulled from columns in another sheet made by Data Validation option. If I
select Pump on the first list and 2 on the second list I would like a list
(say a, b c) to be pulled from another worksheet on the next cell. But if I
select a different seneario with List 1 & 2, List three pulls a different
list.

another example:
List 1: Seal
List 2: 3
List 3: (12, 13, 14)List

List 1: Motor
List 2: 3
List 3: (aa, bb,cc)List

I understand this will probably take some VB code. I am hoping to find some
good example or if someone has some strands of code with some events, ifs,
ands, thens statements that do this I can modify it to my sheet.

Any sugguestions are welcome.
Thanks in advance.