Trying to generate a pivot table with the books examples I already
have was an absolute headache.
What I am trying to achieve now I could have done it much faster with
Access but I need to master Excel VBA.
I need to automate my operations and I will have to return to Pivot
Tables with VBA later on because it offers potentials.
..
Meanwhile, returning to my original code, I identified my problem to
have a summary by Project and Vendor.
..
On the first pass I should have the following values :
Project Vendor PO Value i j k
231 Alpha 8000 2 2 2
..
But in fact j = 4 instead of 2, because it counts all the Vendors of
that name for All projects
The solution I could come up with is to concatenate Project and PO#
and later do a Sumif on that.
'Is it the proper solution ? or am I confused with my syntax ?
Thank you for help
J.P.