Drop Down Lists

M

mafd104

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel

What I am trying to achieve is that when an entry from a list in cell A1 is chosen I would like to be able choose from a list in B1 that has different choices for each entry in the list from A1. So if say 49669 is chosen in A1 then B1 would have a list that contains a,b,c, and if 496L7 is chosen in A1 the choices in the list in B1 would be f,g,h.
 
J

JE McGimpsey

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel

What I am trying to achieve is that when an entry from a list in cell A1 is
chosen I would like to be able choose from a list in B1 that has different
choices for each entry in the list from A1. So if say 49669 is chosen in A1
then B1 would have a list that contains a,b,c, and if 496L7 is chosen in A1
the choices in the list in B1 would be f,g,h.
Click to expand...

See

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

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

How to make repeating drop-down lists? 2
Drop down lists in seperate columns 5
VBA Coding Help for Beginner 0
Custom Number sequences 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Accessibilty - how to open doc with keyboard? 0
Remove checked items from To Do lists 0
If then or look up ? 4

Top