if selection from drop down menu = X, then...

C

Calvin.Lai

My "A" column is the network. Each cell in that column has the same
drop-down menu: NetworkA, NetworkB, etc.

My "B" column is the server name.

What I want is:

If NetworkB is selected for "A1", "B1" will have drop-down menu of list
of servers on NetworkB only.

If NetworkE is selected for "A2", "B2" will have drop-down menu of list
of servers on NetworkE only.

and so on...

How do I go about doing that?
 
M

marcus

Hi Calvin

This should do the trick.

On sheet2, in column A put 'NetworkA' in A1 and 'NetworkB in A2, then
Range
name A1:A2 'List'

In column B, put your Server Names, Server1, Server2, Server3( B1:B3)
and
range name these NetworkA - must be the same as the name in A1.
In column C do the same for NetworkB server names and range name these
NetworkB

Now on sheet 1, say in A1, set DataValidate for List with the souce as

=List

in the next cell to the right, B1 , data validate with List, but set
the source to =Indirect(A1)


Marcus
 

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

Help with creating drop down 1
Pick from drop-down list gives empty or erroneous result 6
Data Validation and drop-down list using IF, AND and what else? 8
Clear a "moving" range offset from Target 31
drop down menu 1
Data Validation List (conditional) 2
Choosing a drop-down menu selection returns value to another cell 2
How to dynamically change the list in drop down list based on thevalue of another cell? 1

Top