Excel 2007 : Resetting Data Validation

[Daniel Brown]

Hello

New to forum and my first thread - there will be more.

I am creating a form using drop-down lists using Data Validation (attached). One drop-down sets the data to be used with other drop-downs and I have encountered two problems that I am unable to resolve.

The first is with the drop-downs that I have highlighted red. I have set the top field to "smoke outlet" and the reference to NAG-S150/100. Change the top drop-down to, say, "Pavement Lights", the Reference drop-down still reads NAG-S150/100. Am I able to reset this field to read choose for example, every time the top field is changed, please?

The second problem is with the data-tables for the Data Validation lists. I am unable to save them onto sheet 2. I want to save the form for customer-use and I do not want them to see this mess.

Any hints, tutorials or alternative method would be appreciated. I cannot include any macros or programming into the form.

Regards

[martindwilson]

best you could do would be dependent validations,
http://www.contextures.com/xlDataVal15.html
or
http://www.contextures.com/xlDataVal02.html
also use named ranges for your lists they can be on any sheet

[Daniel Brown]

Thank you for the information