How to create summary table from data using VBA

See enclosed excel file. It shows "what data i have" and what data i eventually want via a macro.

I basically have this table and i want to summarize it
Consider onlyl Junk1 and Junk2
Sum Col1 by Lotid

see enclosed file.....it might more sense.

I can do this manually via a pivot table but i am not sure how to do it automatically via vba code

thanks for the reply.

How would i do the pivot table in vba to get what i want?

I have these files i am trying to automate the collection and presentation of some data. This is why i am trying to do it via vba. I will try and record a macro like you suggested.

i have not worked much with pivot tables...........in fact none.

I was wondering if i should use pivot tables here or just use a bunch of arrays and do i tthat way? Any thoughts?

Hi welchs101
I have had a go at this in VBA for you
Note that I have written the results to a new sheet called ..er .. 'Results'
Run the macro called 'summarise'
I would agree with RoyUK that using a PivotTable is probably the best route
Barry