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]

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.