rajkumar
02-26-2018, 02:40 AM
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
raj21697
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
raj21697