Validation Filtering

[will07]

I want to use a drop down menu in a cell that will look up a list that will
have different categories in it. My question, can I filter these categores
in the drop down menu : i.e

Paint (cat name)
walls (list name)
ceilings (list name
Plaster (cat name)
single side ( list name)

Hope this all makes sense (and there is an way of achieving it)

Thanks

 

[T. Valko]

See this:

http://contextures.com/xlDataVal02.html