i need pls a macro to copy my data from one worksheet to another after looking for the date and name
example copy from first figure to second
example copy from first figure to second
Description | PeriodStart | Received | Handled Calls | ACD Total Handled Time | AHT | Logged in Time | Global Ready Time | Ratio % | Not Ready Time | Ratio % | Internal/ External Calls | Total Hold Time ACD | Ring No Answer | Transferred | Occupency | Working Day |
agent 1 | 0 | 0 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0.00% | 0:00:00 | 0.00% | 0:00:00 | 0:00:00 | 0 | 0 | #DIV/0! | 0 | |
agent 2 | 0 | 0 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0.00% | 0:00:00 | 0.00% | 0:00:00 | 0:00:00 | 0 | 0 | #DIV/0! | 0 | |
agent 3 | 0 | 0 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0.00% | 0:00:00 | 0.00% | 0:00:00 | 0:00:00 | 0 | 0 | #DIV/0! | 0 | |
agent 4 | 0 | 0 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0.00% | 0:00:00 | 0.00% | 0:00:00 | 0:00:00 | 0 | 0 | #DIV/0! | 0 | |
agent 5 | 0 | 0 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0.00% | 0:00:00 | 0.00% | 0:00:00 | 0:00:00 | 0 | 0 | #DIV/0! | 0 |