If your data are organized in relational form and you want to maintain that
layout, see
Cascading queries
http://www.tushar-mehta.com/excel/ne...wns/index.html

--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu


"Martin" wrote:

Hi,

I have two drop down boxes using data validation, these work fine but what i
would like to do is have the 2nd validation drop down box work off the result
of the first validation drop down box.

Does anyone know how to do that?

Thank you in advance.

Martin