Thank you for Reply...


This is also good option, but don't very much about pivot Table, So please elaborate little. This is not showing Des. Value, It will show after double clicking on cell, Si i have to click on every cell of that row?


This is not updating automatic or manual, Means I have change data in Wrking Sheet it is not updating in Pivot Table. So is there any way to refresh or regenerate to do after changes made in data?


Remark and other things will type manually, so can add extra column next to table, will make any effect to table?






Thank You.

Either: right-click on the cell you're double-clicking on, then:


2022-11-15_094254.png


Or: merely select the cell you're currently double-clicking on, then:

2022-11-15_094752.png

Either:

2022-11-15_095141.png

Or right-click anywhere in the pivot and choose Refresh.

No except that it might stop it expanding to the right if you want to add more columns to it, but more importantly, the comments will not move with rows added/removed when the source data changes and you refresh the pivot. That's why I suggested you copy/paste|Values the pivot to another location which then can't be refreshed, then you can add your comments there.
You could, instead of adding the comments to the pivot table, add them to the source data and include the comments in the pivot table.

Ok... Got it...means I Have to refresh data whenever new data will be added.






There is no more Column Excel 3 Main Columns (Des., Date & Value) and 4 Comment Columns (Blank, Diff in Value, Remark, Blank). Except this there is no any other columns.


Data will updated (Added) Every month in Raw Sheet, only Changes (Delete Old and Start with New Data) will come in New Year.


And Also I have formula below that table that Total Value Less Diff Value, So this will stay as it is or I have to Add when refresh data?




Sorry for trouble, I know that pivot is something in excel but never use it. So i have lots of question about this.


Thank You.