| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for Copying pasting between different spreadsheets
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro for Copying pasting between different spreadsheets
Hi Adnan
I am not sure if I understand you correct but start here http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Adnan" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro for Copying pasting between different spreadsheets
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, "Ron de Bruin" wrote: Hi Adnan I am not sure if I understand you correct but start here http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Adnan" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro for Copying pasting between different spreadsheets
You can change the code here to copy the data to sheets in the Agent Summary workbook
instead of the Agent workbook. http://www.rondebruin.nl/copy5_5.htm I have no time now to create/test it for you now If you have no answer I will help you tomorrow after work in addition to matching the date This is not clear to me (need more info) but first try to get your copy code working -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Adnan" wrote in message ... 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, "Ron de Bruin" wrote: Hi Adnan I am not sure if I understand you correct but start here http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Adnan" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro for Copying pasting between different spreadsheets
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 "Ron de Bruin" wrote: You can change the code here to copy the data to sheets in the Agent Summary workbook instead of the Agent workbook. http://www.rondebruin.nl/copy5_5.htm I have no time now to create/test it for you now If you have no answer I will help you tomorrow after work in addition to matching the date This is not clear to me (need more info) but first try to get your copy code working -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Adnan" wrote in message ... 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, "Ron de Bruin" wrote: Hi Adnan I am not sure if I understand you correct but start here http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Adnan" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro copying and pasting | Excel Discussion (Misc queries) | |||
| Copying and Pasting Macro | Excel Discussion (Misc queries) | |||
| Copying and Pasting Rows Macro | Excel Discussion (Misc queries) | |||
| Pasting data from xl spreadsheets | Excel Discussion (Misc queries) | |||
| Pasting data from xl spreadsheets | Excel Discussion (Misc queries) | |||
Linear Mode
