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)

Date	Agent Name	Waiting For Call	Average Talk Time	Wrap Up	On Hold	Conference	Break	Lunch	ACW	QA	Meeting
1/4	Employee 1	00:06:54	00:08:27	00:05:41	00:00:00	00:00:00	00:30:00	00:37:00	00:15:26	00:42:00	00:17:00
1/4	Employee 2	00:09:54	00:05:39	00:12:49	00:00:00	00:00:00	00:25:15	01:00:52	00:00:00	00:00:00	00:20:00
1/4	Employee 3	00:07:54	00:09:42	00:18:46	00:00:00	00:00:00	00:19:18	00:47:32	00:29:15	00:18:06	00:27:00
1/5	Employee 1
1/5	Employee 2
1/5	Employee 3

<tbody>
</tbody>

Sheet2 - Employee 1

Date	Wrap Up	ACW	Average Talk Time
1/4	00:05:41	00:15:26	00:08:27
1/5
1/6

<tbody>
</tbody>

 

[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...

A​

B​

C​

D​

E​

F​

G​

H​

I​

J​

K​

L​

1​

Employee 1

2​

Date

Agent Name

Waiting For Call

Average Talk Time

Wrap Up

On Hold

Conference

Break

Lunch

ACW

QA

Meeting

3​

4-Jan

Employee 1

0:06:54

0:08:27

0:05:41

0:00:00

0:00:00

0:30:00

0:37:00

0:15:26

0:42:00

0:17:00

4​

5-Jan

Employee 1

0:00:00

0:00:00

0:00:00

0:00:00

0:00:00

0:00:00

0:00:00

0:00:00

0:00:00

0:00:00

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.