Dear Sirs,
I have a problem in getting the pivot table to automatically post its monthly Total in Pivot Table 1 to the respective Column C in sheet Bank whenever the data refreshed in Sheet Data.
If MTH = Apr in pivottable1, Apr total amount post to Column C in Sheet Bank
If MTH = May in pivottable1, May total amount post to Column E in Sheet Bank
If MTH = Jun in pivottable1, Jun total amount post to Column G in Sheet Bank
If MTH = Jul in pivottable1, Jul total amount post to Column I in Sheet Bank
If MTH = Aug in pivottable1, Aug total amount post to Column K in Sheet Bank
If MTH = Sep in pivottable1, Sep total amount post to Column M in Sheet Bank
If MTH = Oct in pivottable1, Oct total amount post to Column O in Sheet Bank
If MTH = Nov in pivottable1, Nov total amount post to Column Q in Sheet Bank
If MTH = Dec in pivottable1, Dec total amount post to Column S in Sheet Bank
If MTH = Jan in pivottable1, Jan total amount post to Column U in Sheet Bank
If MTH = Feb in pivottable1, Feb total amount post to Column W in Sheet Bank
If MTH = Mar in pivottable1, Mar total amount post to Column X in Sheet Bank
Original sheet Bank consists of 34 Bank name. Therefore, I hope that I might get some help from you guys to save a bit of time in manually doing the posting.
Do I need to have a vba programming code to perform the above, or maybe there is some function in the PIVOT TABLE that I have no idea. Pls help me.
I have attach a dummy file for your reference.
Bookmarks