Creating Dependent lists

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate hashtags in OneNote 0
Cell Counter/Increment 2
Search other sheets for numbers & color them 10
Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to a list onsame & another sheet 27
Loop thru xx No. of sheets until the four strValue combo's are found 6
Vlookup or similar 7
Create tables on multiple sheets from list 3
filter function 0

Top