Can Excel transfer data From sheet1 to Sheet2, Sheet3, Sheet4, etc.?

[bm2006]

Hi,

I'm new to this group and I just want to say thank you in advance for any assistance anyone is willing to share.
I work in a fairly new call center and a lot of our data is ran manually, which can be a bit consuming and overwhelming to be working on multiple spreadsheets. With that being said, I created a spreadsheet and I have most of the formulas already enter with the exception of the main purpose of creating this spreadsheet. Let's get started

Our system runs a report that will provide each state and the amount of time an employee was on a specific state. I than copy the information onto sheet 1. From there, I want only certain information transferred to the employees individual sheet. I have provided somewhat of a example below.

I'm familiar with vlookup but that columns are not the same on each sheet since I only need certain data to report. I can't delete anything from sheet 1 because it provides me with the data I need for coaching.

I really hope this is possible. Any help is greatly appreciated.

Sheet 1 (All Data)
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Agent Name[/TD]
[TD]Waiting For Call[/TD]
[TD]Average Talk Time[/TD]
[TD]Wrap Up[/TD]
[TD]On Hold[/TD]
[TD]Conference[/TD]
[TD]Break[/TD]
[TD]Lunch[/TD]
[TD]ACW[/TD]
[TD]QA[/TD]
[TD]Meeting[/TD]
[/TR]
[TR]
[TD]1/4[/TD]
[TD]Employee 1[/TD]
[TD]00:06:54[/TD]
[TD]00:08:27[/TD]
[TD]00:05:41[/TD]
[TD]00:00:00[/TD]
[TD]00:00:00[/TD]
[TD]00:30:00[/TD]
[TD]00:37:00[/TD]
[TD]00:15:26[/TD]
[TD]00:42:00[/TD]
[TD]00:17:00[/TD]
[/TR]
[TR]
[TD]1/4[/TD]
[TD]Employee 2[/TD]
[TD]00:09:54[/TD]
[TD]00:05:39[/TD]
[TD]00:12:49[/TD]
[TD]00:00:00[/TD]
[TD]00:00:00[/TD]
[TD]00:25:15[/TD]
[TD]01:00:52[/TD]
[TD]00:00:00[/TD]
[TD]00:00:00[/TD]
[TD]00:20:00[/TD]
[/TR]
[TR]
[TD]1/4[/TD]
[TD]Employee 3[/TD]
[TD]00:07:54[/TD]
[TD]00:09:42[/TD]
[TD]00:18:46[/TD]
[TD]00:00:00[/TD]
[TD]00:00:00[/TD]
[TD]00:19:18[/TD]
[TD]00:47:32[/TD]
[TD]00:29:15[/TD]
[TD]00:18:06[/TD]
[TD]00:27:00[/TD]
[/TR]
[TR]
[TD]1/5[/TD]
[TD]Employee 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/5[/TD]
[TD]Employee 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/5[/TD]
[TD]Employee 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Sheet2 - Employee 1
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Wrap Up[/TD]
[TD]ACW[/TD]
[TD]Average Talk Time[/TD]
[/TR]
[TR]
[TD]1/4[/TD]
[TD]00:05:41[/TD]
[TD]00:15:26[/TD]
[TD]00:08:27[/TD]
[/TR]
[TR]
[TD]1/5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[FDibbins]

How much data are we talking about here, both in total and per day?

 

[Michael M]

Probably best with a VBA solution would that be something you could use ??
If so, we will need to know how many employees ?
Is the employee name on their individual sheet in cell A1
Does the data on Sheet1 start in Col A and then across in a set range ??

 

[FDibbins]

Try this approach using a helper column on your data sheet.

I used column M, and then...
M2=B2&"-"&COUNTIF($B$2:B2,B2)
copied down
this will create a unique ID for each record

Then on Employee 1 sheet...
[Table="width:, class:grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][td]

F​

[/td][td]

G​

[/td][td]

H​

[/td][td]

I​

[/td][td]

J​

[/td][td]

K​

[/td][td]

L​

[/td][/tr]
[tr][td]

1​

[/td][td]Employee 1[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]

2​

[/td][td]Date[/td][td]Agent Name[/td][td]Waiting For Call[/td][td]Average Talk Time[/td][td]Wrap Up[/td][td]On Hold[/td][td]Conference[/td][td]Break[/td][td]Lunch[/td][td]ACW[/td][td]QA[/td][td]Meeting[/td][/tr]

[tr][td]

3​

[/td][td]4-Jan[/td][td]Employee 1[/td][td]0:06:54[/td][td]0:08:27[/td][td]0:05:41[/td][td]0:00:00[/td][td]0:00:00[/td][td]0:30:00[/td][td]0:37:00[/td][td]0:15:26[/td][td]0:42:00[/td][td]0:17:00[/td][/tr]

[tr][td]

4​

[/td][td]5-Jan[/td][td]Employee 1[/td][td]0:00:00[/td][td]0:00:00[/td][td]0:00:00[/td][td]0:00:00[/td][td]0:00:00[/td][td]0:00:00[/td][td]0:00:00[/td][td]0:00:00[/td][td]0:00:00[/td][td]0:00:00[/td][/tr]
[/table]
A3=IFERROR(INDEX(Sheet3!A:A,MATCH($A$1&"-"&ROWS($A$1:A1),Sheet3!$M:$M,0)),"")
copied down and across as needed

 

[bm2006]

I have a total of 30 employees.
The sheet is named under the employee, but I don't have the employees name on the actual spreadsheet. I don't have a problem adding it if it helps.
Last, the date is in column A and then runs across.

 

[bm2006]

FDibbins, It's going to have the running data for all year.

 

[Michael M]

I'd run with Fords option first if you can.....otherwise post back and we may be able to help with a VBA solution

 

[bm2006]

Ford,

Thank you but it doesn't seem to be working.

 

[FDibbins]

Did you add the helper column and copy the formula down?

 

[bm2006]

Ford,

It finally worked. I must of been doing something wrong because I was so tired. I just want to thank you so much for your help. This is going to save so much time.