I run a report everyday and copy the statistics into another excel
spreadsheet. The report I run has 17 names on it and the stats are for the
day before. I copy each persons stats into the 2nd spreadsheet, however each
person has a workbook named after their initials. Example below

Report would show the following information

AVG TOTAL TOTAL TOTAL TOTAL TOTAL
ACD TALK AFTER AVAIL AUX/ TIME HOLD
CALLS TIME CALL TIME OTHER STAFFED TIME
Agent Name: John Smith
4/1/2009 29 2:12 0:28:22 5:05:27 1:30:04 8:08:19 0:00:19
Agent Name: John Doe
4/11/2009 27 2:45 0:41:34 3:52:16 1:16:57 7:04:40 0:04:26
Agent Name: Roger Fed
4/11/2009 27 4:00 0:00:00 2:59:24 2:21:09 7:01:09 0:16:04

I copy the columns from ACD CALL through TOTAL HOLD TIME from the report and
paste it into the worksheet named JS in the 2nd spreadsheet. I do the same
for John doe(worksheet JD) and Roger Fe(RF worksheet). I need to build a
macro where I would run the report and clean it up and then run the macro so
that the stats are copied into the respective spreadsheets. Each worksheet
has dates in the first column and I need to ensure 04/01/2009 from the report
goes into 04/01/2009 row in the spreadsheet. How do I create the macro? Below
is a sample of the worksheet that I store the stats into

ACD Avd talk Total Total Total Aux Total Total hold time
Time After call Avail. Staffed
4/1/2009 49 2:39 0:00:00 3:15:10 2:36:50 8:01:45 0:19:14
4/2/2009 53 3:46 0:00:46 1:41:19 2:57:56 8:00:02 0:13:35
4/3/2009 49 2:46 0:00:00 2:10:25 2:34:26 7:00:45 0:14:31
4/6/2009 72 2:34 0:29:09 2:32:00 1:53:28 7:59:43 0:27:15
4/7/2009 47 3:17 0:00:02 2:44:25 2:52:05 8:10:46 0:12:50
4/8/2009 44 4:38 0:14:08 1:43:43 2:38:45 8:00:22 0:18:39
4/9/2009 34 3:47 0:00:00 2:07:15 3:45:02 8:00:10 0:11:34