Please can anyone give me any assistance on the following?
I want to set something to input data/values into cells automatically when criteria is met from a particular drop down box.

I assume this can be done by a macro in VBA - i do not have much experience in VBA (sorry)
But other than that I consider myself quite app in other areas in excel

Example:
A1=drop down box from criteria

Criteria info
C1=pelmet
D1=2500
E1=60

C2=Cornice
D2=2500
E2=90

A10=length (2500)
A11=Height (60)

So if criteria is selected it will override any data already inserted in A10 and A11.

I hope this makes sense - thank you guys.
Andy.