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

On Wednesday, June 27, 2012 7:19:58 AM UTC-5, psanghvi wrote:
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




--
psanghvi

If you like, send your files to ME and I'll take a look.

Hello,

Appreciate the help. Please find attached 2 files. Macro to be placed in the Daily Tracker file to move numbers to master. One sample manual copy paste is illustrated.

Thanks a ton again!!

Hello,

Anyone on some insight into the request?

Thanks again!