How do I summarize from Sheet1, Purchase Order Amount, by Project &
Vendor
into Sheet2, with VBA only, not thru a direct Pivot table.
Data is already sorted by Project & Vendor
..
Data Source : Sheet1
Column A : Project Code
Column B : Vendor Name
Column C : Purchase Order #
Column D : Purchase Order Amount
..
How do I use a Dynamic Sumif to achieve this Summary ?
Help appreciated,
..
Celeste