ah, I understand the confusion now

I don't need the code to enter the dates, I've done that already (column A contains a whole year in dates)

Upon opening the workbook the code only needs to check whether a weight is present on all dates except for the current. Something like this:

..............A..........B........C
146.......5/25.......70
147.......5/26.......
148.......5/27.......
149.......5/28.......
150.......5/29.......
151.......5/30.......
etc

in this case (A149 being the current date) the only thing that should be happening is cell B146 being copied down to cell B147 and B148 and "Automated entry" being added to C147 and C148

hope that clears it up?

btw: thanks so much for helping me!