Hello,

I have a daily tracker spreadsheet wherein each day my employees enter the number of calls they have made. The spreadsheet has a dedicated cell (C1) where the date is mentioned (dd/mm/yy). Just below that, names of the employees are mentioned, one below the other (C4:C10). Alongside this, the numbers are mentioned for calls that are made. (D4:D10).

I would like a macro which copies the above data & pastes it in a master spreadsheet that contains the date (rows) and the employee names (columns).
Once the relevant number is pasted in the master spreadsheet, the daily tracker spreadsheet numbers and date can be erased so fresh entries can b made the subsequent day.

Your help is much much appreciated.

Thanks