I have a list with employees utilization showing payroll vs. billable hours and dollars. One employee could be listed 6 times on the YTD sheet. The YTD total sheet pulls each employee over from each month which has it's own sheet, which has resulted in multiple lines for the same employee. I want to pull each employee name and total each entry for an actual YTD Total. Tried to attach and example but it won't let me. Pasted below is what I'm working with but it doesn't show up well. Gives you an idea though. Any help would be appreciated. Thank you
EmpName EmpID ARHours ARDollars PayrollHours PayrollDollars HoursPercent DollarsPercent
Employee 1 300223 56.00 $3,528.16 56.00 $2,450.00 100.00% 144.00%
Employee 1 300223 160.00 $6,300.20 136.00 $5,950.00 85.00% 105.88%
Employee 1 300223 11.00 $232.98 72.00 $3,150.00 654.55% 7.39%
Employee 1 300223 136.00 $7,132.56 104.00 $4,550.00 76.47% 156.75%
Employee 1 300223 227.00 $24,300.00 184.00 $8,050.00 81.06% 301.86%
Employee 1 300223 0.00 $0.00 16.00 $700.00 0.00% 0.00%
Employee 2 265590 91.00 $5,340.00 80.00 $4,000.00 87.91% 133.50%
Employee 2 265590 114.00 $4,207.31 136.00 $6,800.00 119.30% 61.87%
Employee 2 265590 424.00 $22,278.36 344.00 $17,200.00 81.13% 129.52%
Employee 2 265590 176.50 $6,164.75 112.00 $5,600.00 63.46% 110.08%
Employee 3 271995 51.00 $1,702.26 0.00 $0.00 0.00% 0.00%
Employee 3 271995 144.80 $6,561.60 376.00 $18,800.00 259.67% 34.90%
Employee 3 271995 47.00 $1,920.73 40.00 $2,000.00 85.11% 96.03%
Employee 4 311430 0.00 $0.00 216.00 $7,423.92 0.00% 0.00%
Employee 5 320737 187.50 $9,269.00 272.00 $11,900.00 145.07% 77.89%
Employee 6 305629 200.50 $4,310.75 232.00 $8,700.00 115.71% 49.54%
Employee 6 305629 379.50 $17,968.68 368.00 $13,800.00 96.97% 130.20%
Employee 6 305629 271.00 $9,420.45 200.00 $7,500.00 73.80% 125.60%
Employee 7 320318 193.50 $12,014.25 152.00 $6,650.00 78.55% 180.66%
Employee 7 320318 30.70 $847.32 96.00 $4,200.00 312.70% 20.17%
Employee 7 320318 160.00 $6,340.84 152.00 $6,650.00 95.00% 95.35%
Employee 7 320318 148.50 $4,974.75 120.00 $5,250.00 80.81% 94.75%
Employee 7 320318 0.00 $0.00 24.00 $1,050.00 0.00% 0.00%
Bookmarks