Create Dependent Lists

[Esperite]

Thanks in advance for reviewing this, I know there are probably simple solutions, but I'm having challenges at this point...

I'm creating a spreadsheet that will contain two cells with drop-down lists..

On Sheet2, I've defined Four named-lists...for the sake of argument "OS_LIST" ,"AS400_Servers", "UNIX_Servers", and "WIN_Servers"

"OS_LIST" contains 3 values "AS400", "UNIX", "WINDOWS"
The DropDown Cell is in Sheet1:B2...works fine...

The other named lists have their respective server dns-names listed.

What I want to do, is have my 2nd drop-down cell (Sheet1:D2) automatically just list the relevent servers that are selected in the "OS DropDown"..

For instance, if the selection in B2 is "AS400", then I want the dropdown in D2 to just show the servers in the "AS400_Server" list...and so forth for the other potential selections in the first drop-down..

I know this isn't ground-breaking, but could sure use the nudge in the right direction...

Thanks,
Phil (NJ)

[VBA Noob]

Link should help

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

VBA Noob

[Esperite]

..so useful....