How to make a dropdown list cell default to blank, after another cell selection is made

Hi

I have no idea how to eve attempt this , so i hope someone can help.. I want the second dropdown list to default to BLANK, each time a new selection is made in the first dropdown list.. I.e i would like cell E306 to clear each time a selection change is made in cell D306.

I have supplied the file for your attention and thank you for any assistance you can provide..

Hi

Could anyone spare the time to let me know where i may be able to find this information on the forum, or other location on the internet.. Im would like to understand, and im sure it is possible, i just don't seem to be able to find the information.. I would be very grateful for any assistance..

Regards

Richard

Pl see the attached file.Worksheet_change event is used.

Hi

Thanks for the info... I have looked up the command Worksheet_change event and i now understand another command, or at least what you have done... Its a function i have not heard of and now something i can explore further... I am very grateful for your reply and assistance!!!

If Target.Address = "$D$306" Then
[E306] = ""

Thanks .Pl mark thread SOLVED.