Macro for Copying pasting between different spreadsheets

  • Thread starter Thread starter Adnan
  • Start date Start date
A

Adnan

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
 
Hi Ron,

Lets say the report I run is called Agent. I need to export the data from
the Agent file to Agent Summary. Agent only has 1 worksheet with the name of
all agents on it. However Agent Summary has a worksheet for each agent. How
to I copy data from Agent into Agent Summary, ensuring that it is copied into
the correspoding agents worksheet in addition to matching the date. I hope
this makes more sense.

Thanks,
 
Thanks for replying. I will try the code and see if i can get it to work. If
there is anything else you can recommend, please le tme know.

Thank you
Adnan
 
Back
Top