I have a column in Excel that I created a drop-down list for that applies to the entire column. If I put my mouse cursor on any cell in this column including rows with no data, the drop-down box appears and I am able to pick from that list. On this worksheet I want the most current record on top of the data list right under the titles so I created a button to add a row there. This all works okay except for the added rows do not have the drop-down box in this specific cell.

Also, I have been able to add a check box in a different column of this same sheet but I can’t figure out how to have this checkbox appear in this certain column each time a record is added. I don’t want the checkbox until there is data in this row. Again, when I insert a new row directly under the title row I need this checkbox to be in that certain column for that new record as well.

Thanks