Hi there,
I have a drop down list which has options in such as Blue, Green, Yellow, Pink.
If I have a dropdown option in every cell in Column A and I select Blue in A1, but I want it to go in every cell down to A37 for example. Instead of having to do it manually I want to be able to type 37 in a cell and it will automatically fill all the cells in column A down to A37 with Blue.
Is this possible?
Many Thanks