Moving Amounts to Another Workbook Based on 2 Conditions - Date/Employee

[psanghvi]

Hello,

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

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

Your help is much much appreciated.

Thank

 

[Don Guillett]

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. (D410).

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

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

 

[psanghvi]

Hello,

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

Thanks a ton again!!

;1603199']On Wednesday, June 27, 2012 7:19:58 AM UTC-5, psanghv
wrote:-

Hello,

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

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

Your help is much much appreciated.

Thanks

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

+-------------------------------------------------------------------
|Filename: Desktop.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=440
+-------------------------------------------------------------------

 

[psanghvi]

Hello,

Anyone on some insight into the request?

Thanks again!

Hello,

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

Thanks a ton again!

+-------------------------------------------------------------------
+-------------------------------------------------------------------