luckykamal26
New Member
- Joined
- Aug 25, 2020
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Hi,
I have the below data in "sheet1"
I want a VBA for the data to be looked in the following way in "sheet2". Is there a way / VBA or pivot way to do so:
Please help.
Thanks
K
I have the below data in "sheet1"
Provider | Number Of Tasks | Number of OLA Fulfilled | Priority | OLA Fulfilled % |
Pbonk | 2 | 1 | Prio 2 | 50% |
Fiscal | 3 | 0 | Prio 2 | 0% |
Pbonk | 12 | 7 | Prio 1 | 58% |
Fiscal | 1 | 0 | Prio 1 | 0% |
Fiscal | 10 | 3 | Prio 3 | 30% |
Pbonk | 82 | 59 | Prio 1 | 72% |
Fiscal | 14 | 1 | Prio 1 | 7% |
Pbonk | 87 | 23 | Prio 3 | 26% |
I want a VBA for the data to be looked in the following way in "sheet2". Is there a way / VBA or pivot way to do so:
Provider | Prio 1 | OLA 1 Fulfilled | OLA 1 Fulfilled % | Prio 2 | OLA 2 Fulfilled | OLA 2 Fulfilled % | Prio 3 | OLA 3 Fulfilled | OLA 3 Fulfilled % | Overall | Overall Fulfilled | OLA % Fulfilled |
Pbonk | 94 | 66 | 70.21% | 2 | 1 | 50.00% | 87 | 23 | 26.44% | 183 | 90 | 49.18% |
Fiscal | 15 | 1 | 6.67% | 3 | 0 | 0.00% | 10 | 3 | 30.00% | 28 | 4 | 14.29% |
Please help.
Thanks
K