This is what I'm trying to do, I have a column of cells to fill in.  I want to be able to select an object from a drop list and have it fill in the column designated.  If there is something in the first and or second cells, I would like it to fill in the next one or two cells next down and so on.  This step will continue as items are selected out of the drop down list until the block of cells in the designated column are full.

1 Reply