1 Attachment(s)
Copy and paste total row with engineer name and headings to a new worksheet
Hi ,
i have a report with engineer performance , i need to copy the total row in each engineer with engineer name and parameter heading in vba
Engr Name |
Model |
Prod Group |
Prod Family |
CR Calls |
Inst. Calls |
PM Calls |
Total Calls |
Brkn Calls |
BC Parts |
BCTech Engr. |
BCTech Alert |
BC Emertel |
BC Lock |
BC Defect |
BC Cross Check |
BC Appr Await |
BC MC Obser |
BC In comp |
BC Parts Perc. |
BC Tech engr. |
BC Tech Alert Perc. |
BC Other Perc. |
Obs. Time |
CBC |
DBC |
Cqm perc. |
Job Time |
Travel Time |
Utilization Factor
|
Total: |
12 |
0 |
4 |
16 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
- |
- |
- |
- |
0 |
|
|
87.50% |
34.15 |
46.8 |
46.97 |
i have attached a copy of the workbook here.
please help
regards
rajAttachment 21697