Good day,
I am searching for a macro/vba code which does the following:
1/ Loop through all items of a specific pivot table field (in the example: BASIN)
2/ Copy then one after the other the corresponding result computed in sheet "Gap_Calculation" and transferred to sheet "GAP" into a summary sheet where all are stored.
There are usually per item of BASIN 4 results to be calculated: one for market division A, one for market division In, one for market division PA and one for all these 3 market divisions.
How to do this?
Thanks a lot in advance
Best regards
Heinz
Bookmarks