Copy cell to next open row

[Teblol]

Hi All,

Is there a formula to copy text in row 3 to the next empty row? I want to enter todays date in A3, Time in in B3, and Time out in C3 and have it automatically entered in the next blank row. Attached is a copy of what I want.

Mom Work.xlsm

[Richard Buttrey]

Hi,

Not with a formula. You can do it with a macro - see attached.

[Teblol]

Thank you so much! I am also having trouble adding the pay automatically. I should be able to put =D6*8 into column E but it does not work. Any ideas?

Thanks

[sourabhg98]

Hello
I have made the macro
See the attachment.
I have also made that multiplication thing.
Ask for any kind of further help.



If you do like my post, then kindly click on add reputation
Regards!!
Sourabh Gupta

[sourabhg98]

Hey I have added one more feature i.e. to find total between any two dates---
Hope you would like it..

If you do like my post, then kindly click on add reputation
Regards!!
Sourabh Gupta

[Teblol]

Thanks for the help sourabhg98.