Drop-Down in each row with data

[14spar15]

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

[NoSparks]

Can you create and attach a sample workbook exhibiting what you are describing and would like assistance with ?

[14spar15]

Hello, thanks for the reply. Would I be attaching a whole .xlsm file?

[NoSparks]

Yes, but only need a sample, you can strip it down to just what you're dealing with.