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:
And data formatted like this:
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.
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 | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | I | J | |||
| 1 | WEDATE | StaffTime | LawsonID | Name | LastName | FirstName | StartDate | Coach | Date | ||
| 2 | 5/12/2007 | 555555 | Last,First1 | Last | First | 1/23/2006 | CoachName | 5/10/2007 | |||
| 3 | 5/12/2007 | 555555 | Last,First2 | Last | First | 9/3/2002 | CoachName | 5/11/2007 | |||
| 4 | 5/12/2007 | 555555 | Last,First3 | Last | First | 9/16/2002 | CoachName | 5/11/2007 | |||
Agent Trade Data | |||||||||||
And data formatted like this:
| Copy of M50 Scorecardblanked.xls | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | WEDate | Date | LastName,FirstName | StaffTime(hrs) | ||
| 2 | 5/12/2007 | 05/11/2007 | Last,First1 | 0.001388889 | ||
| 3 | 5/12/2007 | 05/11/2007 | Last,First2 | 5.323888889 | ||
| 4 | 5/12/2007 | 05/11/2007 | Last,First3 | 2.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.
