On Mar 14, 7:47*am, 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.

I am one who does NOT like pivot tables. You can use SUMPRODUCT
formulas or vba to do the same thing

"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."