I apologize but I forgot to mention that the data on the register will change regularly. So I will need it to enter in the data for the new dates each time the macro is run but not remove the previous dates data. This is why I need a macro instead of a formula.

I have a large Macro that does everything else. This one thing I am having a hard time getting accomplished.