ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pivot table refresh problem (https://www.excelbanter.com/excel-programming/435349-pivot-table-refresh-problem.html)

John[_140_]

Pivot table refresh problem
 
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?




All times are GMT +1. The time now is 08:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com