Another option is to create cross-dependent validation lists, as in the
sample workbook he

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

Under Data Validation, look for 'DV0013 - Cross Dependent Validation Lists'

MrBold wrote:
I have two data validation drop down boxes that are linked. 1. Select brand.
2. Select Colour . The colour options list (box 2) is different depending on
which brand is selected.
It works great when starting from a blank sheet, but after making a
selection in both 1 and 2, if you go back and select a different brand in box
1, it will still display the colours from the prevoius brand selection in box
2 and result in an error in the total column.
Is there any way I can get box 2 to clear when a new selection is made in
box 1?

Thanks for your help.



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com