Hi everyone I'm a real fan of all of your work. I need some help though. This seems really simple in my head so hopefully I can explain it well enough.

I'd like to run a macro/sub that does the following.

Copy cell "A1"
Paste special Value to cell "B1"
If B1 has content already, paste special value to cell "B2"
If B2 has content already, paste special value to cell "B3"
etc etc etc

To put it in context I'm making a very basic punch clock.
A1 is =now() and I would like to capture that time using paste special value to generate a list of punches.

Thanks!