J
John
I have a two column pivot table, to the right of that is a column for
comments, outside of the PT, like this:
A B C
PT data PT data Comment1
PT data PT data Comment2
Etc etc
When I refresh my pivot table and add or delete a row to it, the data, of
course, no longer aligns correctly with its respective comment. I can't
make the Comments column a part of the pivot table because you can't change
part of a pivot table (can't make comments). Any ideas on how to align the
comments with their respective rows upon refresh?
comments, outside of the PT, like this:
A B C
PT data PT data Comment1
PT data PT data Comment2
Etc etc
When I refresh my pivot table and add or delete a row to it, the data, of
course, no longer aligns correctly with its respective comment. I can't
make the Comments column a part of the pivot table because you can't change
part of a pivot table (can't make comments). Any ideas on how to align the
comments with their respective rows upon refresh?