Combining Data to One Sheet

calming.insanity

New Member
Joined
Apr 27, 2007
Messages
22
Hello,
I am trying to compile data that comes from 2 reports into one that can then be pivoted and am kinda stuck.

I have data formatted like this:
Copy of M50 Scorecardblanked.xls
BCDEFGHIJ
1WEDATEStaffTimeLawsonIDNameLastNameFirstNameStartDateCoachDate
25/12/2007555555Last,First1LastFirst1/23/2006CoachName5/10/2007
35/12/2007555555Last,First2LastFirst9/3/2002CoachName5/11/2007
45/12/2007555555Last,First3LastFirst9/16/2002CoachName5/11/2007
Agent Trade Data



And data formatted like this:
Copy of M50 Scorecardblanked.xls
ABCD
1WEDateDateLastName,FirstNameStaffTime(hrs)
25/12/200705/11/2007Last,First10.001388889
35/12/200705/11/2007Last,First25.323888889
45/12/200705/11/2007Last,First32.635
Staff Time


All I need to do is put the staff time beside each agent's name so i can pivot the data. There will be multiple agents, we dates and dates in the same reports. Anyone know of a formula to do this, as i have been just using vlookup on the name for that date and it gets time consuming.
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,129,552
Messages
5,636,975
Members
416,953
Latest member
broexc

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