Data Validation

[atmospheric]

I need two drop down lists, the second being dependant on the chosen result of the first. For example, list one has three choices of materials, Sheets, Bars and Tubes. If "Tubes" is chosen, list two must only display the sizes of Tubes available, ditto for Sheets and Bars. Creating the lists is not a problem, but how can I make the second dependant on the first??
Your help greatly appreciated

 

[Brian from Maui]

Try this,

http://www.mrexcel.com/board/viewtopic.php?topic=9267&forum=2

there's also another link to Aladin's drop down, but I can't find it

found it!

http://www.mrexcel.com/board/viewtopic.php?topic=40&forum=2&7
This message was edited by Brian from Maui on 2002-07-17 15:26

 

[atmospheric]

Thanks Brian......9 minutes for an answer!! Going to try it now.......let you know

 

[Dave Hawley]

Hi

I have some working examples of these here:http://www.ozgrid.com/download/default.htm

"MatchingLists.zip"
"DynaRange.zip"
"ListMatch.zip"

Hope they help.

 

[atmospheric]

Thanks Dave and Brian, sorted now. What a fantastic site, wish I'd found it years ago!!