What makes Pivot to not be the obvious choice? What don't you like
about it?

On Mar 14, 12:47*pm, darkblue wrote:
Column A: Sales Person
Column B: Item
Column C: Amount

Sample data is like (Max number of rows: 5000)

John, * * Item1, 2000
George, Item4, * 800
Anna, * *Item2, * 340
Adam, * Item7, * 960
John, * * Item2, * 200

I know i can easily apply a pivot table to analyse the sales
as i am currently doing. But i was wondering if i can do
it by vba code. I know how to pull the unique names out of the list.
And the rest seems to be looping and summing. Maybe you guys are
using a different method that is why i am asking.Or should i stick to
pivot ?
Thank you in advance.