I understand how to set up Validation and enter a formula identifying the
cells for the contents of the drop down box. However, when I go to the column
and attempt to click on the cells/drop down boxes, the number of
options/items in the drop down box items decreases by one as I move down a
cell at a time until there are no contents in the cell at all.