Copy data from one worksheet to another based on date

[OAM]

I am using Ron De Bruin's macro shown below to copy data from one worksheet to another and it works well until the operator has a problem, runs the macro again, and the data gets copied twice, then I have duplicate data. What I need to know, can the code be adapted or a new macro to only copy today's data and if run again it would not add today's data twice to the other worksheet.

Is this possible? Thank you for your help!

Please Login or Register  to view this content.

[OAM]

I found another code from Ron De Bruin that deletes the entire row if the date equal today so this work for me.

Thanks to everyone who looked at this post and a big thank you to Ron De Bruin for the code shown below, this code and the one on the original post work flawlessly.

Please Login or Register  to view this content.