Excel_Grass
New Member
- Joined
- Jul 8, 2014
- Messages
- 1
Hi All, I am an excel newbie, please help,
I created a pivot table, and inserted few new columns next to pivot and put in some comments on each row next to pivot table.
The root cause of my problem is that those edits on each row outside pivot table is not linked to the row within the pivot table, so when i make changes in the pivot, resulting the original information move to new rows in pivot table, but the "matching" information outside pivot stayed on the old row, resulting a mis-match.
Question, how do i tag the comment on each row outside pivot with each row within pivot? or is there better alternative to achieve what i want to do?
Big thanks!
David
I created a pivot table, and inserted few new columns next to pivot and put in some comments on each row next to pivot table.
The root cause of my problem is that those edits on each row outside pivot table is not linked to the row within the pivot table, so when i make changes in the pivot, resulting the original information move to new rows in pivot table, but the "matching" information outside pivot stayed on the old row, resulting a mis-match.
Question, how do i tag the comment on each row outside pivot with each row within pivot? or is there better alternative to achieve what i want to do?
Big thanks!
David
