Autofill Drop Down Box

[strugglingwithmacexcel]

Hi

This is my first post. I'm wanting to know if there is a way to auto fill a drop down box.
For example I have a drop down box in Cell A1 which has an input range of $E$1:$E$4 and a cell link to Cell A1.
I now want to have another drop down box in Cell A2 with the same input range and but with a cell link to Cell A2.
I want to do this several times and at the moment I have just been copying and pasting the drop down box and changing the cell link reference manually. Is there an easier way to do this where excel can do it for you?

 

[teylyn]

An easier way? Not really if you use the form controls in a sheet. Why don't you use data validation with the list option instead? The selected value is stored in the same cell as the dropdown.