How to make PivotTable filter and sort affects the entire Row of the sheet?

[msheikh]

I have a PivotTable and beside it I have added a Comment column beside the PivotTable (outside the pivot and aligned with each row in the pivot), which is a free text column and not connected to the data source of the PivotTable.
When sorting, filtering or refreshing the PivotTable the Comment column stands still, and not aligned with the new order or filter of the PivotTable.
I want to the sorting, filtering and refreshing of the Pivot to affect the entire Row and not only the PivotTable data columns.
Any help?

 

[wist]

Hi, I need to do the same, no idea if possible, any ideas? Thanks