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