strugglingwithmacexcel
New Member
- Joined
- Oct 23, 2013
- Messages
- 1
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?
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?