I would like to have a column of drop down list boxes referenced to a list
of attendance issues. Say in d1:d10 Sick, sick child, loa, iloa, etc. When I
try to copy them they all change together is their an efficient bit of code
for a situation like this?

Thank you

David