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>
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

FDibbins

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
How much data are we talking about here, both in total and per day?
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
20,168
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
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

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
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​
DateAgent NameWaiting For CallAverage Talk TimeWrap UpOn HoldConferenceBreakLunchACWQAMeeting
3​
4-JanEmployee 10:06:540:08:270:05:410:00:000:00:000:30:000:37:000:15:260:42:000:17:00
4​
5-JanEmployee 10:00:000:00:000:00:000:00:000:00:000:00:000:00:000:00:000:00:000: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

New Member
Joined
Mar 24, 2016
Messages
6

ADVERTISEMENT

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.
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
20,168
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows

ADVERTISEMENT

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

New Member
Joined
Mar 24, 2016
Messages
6
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,916
Messages
5,638,976
Members
417,063
Latest member
thematulaak

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