Hi p45cal
Thank you for efforts and sorry for late reply.


I have check file which you attached. But the Diff Values I have to enter manually as it need to calculate from Physical papers(Statements of 3 Banks). So I can not create fetch or automated work. So for that I'll convert this data in to Month Wise and easily update Diff value and Comments month by month and after that check that Total value and Total of Diff Value of that month.


There for I require to convert data directly into separated months, so i need not to convert and totaling to do manually in each month and every time when get new data. So if pivot table work in that way then please help me.





By the way this is great tool Pivot Table (I never use it before) which I learned from you, I'll sure use it into my presentation sheet.


Thank You.