Keep a column of comments with pivot table as pivot tables datachanges

[ritchieexcel]

We have a pivot table tracking supplier data. A few users share the

spreadsheet to make adhoc comments next to supplier names. Because the

data changes often, the number of rows in the pivot table can change,

meaning that supplier ACME can move up and down, so the comments in

the row get out of sync.

Ie the pivot table takes columns A to E. Text comments are added in

column F.

So Row 10 may be the pivot table row with ACME, and a user adds a note

in cell F10.

Then the pivot table underlying data changes, and ACME gets pushed

down to row 11. How can we have the free text in cell F10 also move

down to row 11? I know this is a bit tricker than it seems (what

happens if ACME disappears from the pivot table) but still I'd like to

hear any ideas.

I have also tried making cell comments (right click on a cell and select "insert comment") but when refreshing the data the comments are lost.

Even the ability to highlight a row of data to indicate it has been checked where that specific row remained highlighted when refreshing the data and additional rows of data gets added would be useful.

I just wondered if there was a way to get data next to a pivot table sharing in row movements.

Thanks

Ritchie Campbell

 

[Hui]

Ritchie


Firstly, Welcome to the Chandoo.org forums.


Why not put the comments in a a column next to the Pivot Table

Then retrieve the comments by using a Index/Match off a Row Header in the Pivot Table

The comments can be stored in a column in your original data or elsewhere

This way they will move as the data is updated

 

[NARAYANK991]

Hi Ritchie ,


To add to what Hui has already explained , check out this link :


http://www.pivot-table.com/excel-pivot-tables/problems-with-pivot-table-comments


Narayan