marcus
12/15/2006 12:31:00 AM
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
Calvin.Lai@shaw.ca wrote:
> 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?