A
Alex H
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.
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.