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]

awesome, glad you got it working, and thank you for the feedback

 

[bm2006]

It was the helper that I skipped. Just can't thank you enough.