Compiling data from multiple worksheets in a workbook

F

frostym54

New Member
Joined
Nov 18, 2014
Messages
10
I receive data from the Call Center software each week. In my workbook the data is entered into a worksheet for each week labeled W-01 to W-52. The last sheet is labeled COMP.
Each sheet has three shifts data on it and all sheets are exactly the same. Below the data I copied what the COMP sheet looks like. How can I set up to automatically compile the data as it is entered in the Week worksheet

Thanks
Week of 7/2 to 7/8
3p-11p
agent_name
agent_extension
calls_presented
calls_handled
avg_logon_time
avg_logon_time
avg_idle_time
max_idle_time
avg_hold_time
max_hold_time
avg_talk_time
avg_talk_time
max_talk_time
avg_handle_time
max_handle_time
avg_wrapup_time
avg_wrapup_time
OID WCC01
43471
119
110
04:11:03
4.18
00:06:02
02:46:00
00:00:00
00:00:09
00:01:18
0.02
00:08:53
00:01:18
00:08:53
00:00:00
00:00:00
OID WCC02
43617
71
64
06:53:33
6.89
00:05:03
01:03:44
00:00:02
00:02:16
00:01:27
0.02
00:06:44
00:01:30
00:06:44
00:00:00
00:00:00
OID WCC03
43641
28
25
06:25:30
6.43
00:36:30
05:29:11
00:00:15
00:02:51
00:01:15
0.02
00:04:32
00:01:30
00:05:20
00:00:00
00:00:00
OID WCC04
45223
0.00
0.00
OID WCC05
45589
29
28
02:48:14
2.80
00:01:45
00:10:20
00:00:02
00:00:37
00:01:30
0.03
00:13:52
00:01:33
00:13:52
00:00:00
00:00:00
247
227
4.06
0.018
Abandoned Calls
20
4:03:40
0:01:06
7a-3p
agent_name
agent_extension
calls_presented
calls_handled
avg_logon_time
avg_logon_time
avg_idle_time
max_idle_time
avg_hold_time
max_hold_time
avg_talk_time
avg_talk_time
max_talk_time
avg_handle_time
max_handle_time
avg_wrapup_time
avg_wrapup_time
OID WCC01
43471
125
117
04:00:56
4.02
00:04:57
01:35:43
00:00:00
00:00:09
00:01:23
0.02
00:01:23
00:08:53
00:01:23
00:08:53
00:00:00
OID WCC02
43617
79
71
06:59:10
6.99
00:05:09
01:03:44
00:00:02
00:02:16
00:01:30
0.03
00:01:30
00:06:44
00:01:33
00:06:44
00:00:00
OID WCC03
43641
28
25
06:25:30
6.43
00:36:30
05:29:11
00:00:15
00:02:51
00:01:15
0.02
00:01:15
00:04:32
00:01:30
00:05:20
00:00:00
OID WCC04
45223
0.00
0.00
OID WCC05
45589
26
25
02:09:48
2.16
00:01:53
00:10:20
00:00:02
00:00:37
00:01:36
0.03
00:01:36
00:13:52
00:01:38
00:13:52
00:00:00
258
238
3.92
0.019
Abandoned Calls
20
3:55:05
0:01:09
11p-7a
agent_name
agent_extension
calls_presented
calls_handled
avg_logon_time
avg_logon_time
avg_idle_time
max_idle_time
avg_hold_time
max_hold_time
avg_talk_time
avg_talk_time
max_talk_time
avg_handle_time
max_handle_time
avg_wrapup_time
avg_wrapup_time
OID WCC01
43471
102
95
03:50:12
3.84
00:04:29
01:31:46
00:00:00
00:00:09
00:01:19
0.02
00:08:53
00:01:19
00:08:53
00:00:00
00:00:00
OID WCC02
43617
60
55
06:45:56
6.77
00:05:16
01:03:44
00:00:03
00:02:16
00:01:23
0.02
00:06:44
00:01:27
00:06:44
00:00:00
00:00:00
OID WCC03
43641
28
25
06:25:30
6.43
00:36:30
05:29:11
00:00:15
00:02:51
00:01:15
0.02
00:04:32
00:01:30
00:05:20
00:00:00
00:00:00
OID WCC04
0.00
0.00
OID WCC05
45589
23
22
02:02:52
2.05
00:01:58
00:10:20
00:00:03
00:00:37
00:01:40
0.03
00:13:52
00:01:43
00:13:52
00:00:00
00:00:00
213
197
3.82
0.019
Abandoned Calls
16
3:48:54
0:01:07

3P - 11P
7A - 3P
11P - 7A
ALL SHIFTS
WEEK
avg_logon_time
avg_talk_time
Calls Handled 3P-11P
Abandoned Calls
WEEK
avg_logon_time
avg_talk_time
Calls Handled 7A - 3P
Abandoned Calls
WEEK
avg_logon_time
avg_talk_time
Calls Handled 11P - 7A
Abandoned Calls
Total Calls Handled for Week
2-Jul
4.06
0:01:06
227
20
2-Jul
3.92
0:01:09
238
20
2-Jul
3.82
0:01:07
197
16
662
9-Jul
4.61
0:00:48
249
16
9-Jul
4.51
0:00:48
252
17
9-Jul
4.15
0:00:48
214
13
715
16-Jul
4.86
0:00:54
271
13
16-Jul
4.31
0:00:55
250
11
16-Jul
4.66
0:00:54
270
13
791

<tbody>
</tbody>







<tbody>
</tbody>
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
You must log in or register to reply here.

Similar threads

K
  • Solved
Reorder the 3 column data into 2 columns of 24 rows
Replies
6
Views
115
Fluff
Fluff
K
  • Question
Excel Pivot table Time Values is not populating same as Source Sheet
Replies
1
Views
347
awoohaw
awoohaw
J
  • Solved
Excel "Strava Best Effort" Calculation
2
Replies
13
Views
473
felixstraube
F
M
  • Solved
Returning results based on multiple criteria
Replies
5
Views
318
DanteAmor
DanteAmor
A
  • Solved
Macro getting stuck on average when no data is present
Replies
5
Views
285
amphead
A

Forum statistics

Threads
1,216,113
Messages
6,128,904
Members
449,477
Latest member
panjongshing

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top