Vba code to perform pivot like fuction.

[Sushil.thakur]

Hi please help me with the code which work like a pivot
i have following data
Date Name Acc WAcc RAcc
16-Aug-12 Ram 5 2 1
16-Aug-12 Prem 7 4 3
17-Aug-12 Ram 2 2 1
17-Aug-12 Shyam 3 3 2
18-Aug-12 Ram 8 1 1
18-Aug-12 Shyam 9 2 2
20-Aug-12 Ram 6 4 3
20-Aug-12 Prem 7 2 1

And i want result as
Name Acc WAcc RAcc
Prem 14 6 4
Ram 21 9 6
Shyam 12 5 4
Gr 47 20 14

i.e total number of accounts, worked accounts and resolved accounts by each candidate

Please help

[Kyle123]

Why not just use a pivot table?

You can create a pivot table with a macro, try using the macro recorder whilst you do it

[Sushil.thakur]

Book5.xlsxBook5.xlsxHi Kyle Thanks for your suggestion, but problem is littel diffrent.
Please find the attached sheet and suggest how can i resolve the problem.