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

bm2006

New Member
Joined
Mar 24, 2016
Messages
6
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)
DateAgent NameWaiting For CallAverage Talk TimeWrap UpOn HoldConferenceBreakLunchACWQAMeeting
1/4Employee 100:06:5400:08:2700:05:4100:00:0000:00:0000:30:0000:37:0000:15:2600:42:0000:17:00
1/4Employee 200:09:5400:05:3900:12:4900:00:0000:00:0000:25:1501:00:5200:00:0000:00:0000:20:00
1/4Employee 300:07:5400:09:4200:18:4600:00:0000:00:0000:19:1800:47:3200:29:1500:18:0600:27:00
1/5Employee 1
1/5Employee 2
1/5Employee 3

<tbody>
</tbody>

Sheet2 - Employee 1
DateWrap UpACWAverage Talk Time
1/400:05:4100:15:2600:08:27
1/5
1/6

<tbody>
</tbody>
 

FDibbins

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
awesome, glad you got it working, and thank you for the feedback :)
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Watch MrExcel Video

Forum statistics

Threads
1,129,908
Messages
5,638,932
Members
417,059
Latest member
clinical

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
Top