Copy and paste macro button based on a condition [Closed]

Report
Posts
2
Registration date
Thursday June 30, 2016
Status
Member
Last seen
June 30, 2016
-
I have daily time I am entering for employees in a worksheet. It is summarized in a table at the bottom of the worksheet. When today's data is entered I want to use a macro button to copy and paste the summarized data based on the date I enter the data to another table with that date at the top and clear column range.

If (Today's Date) C3 = (Destination Table) A92
Then Copy range B76:D88
Paste in cell B93
Clear column range E3:F68

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!