B
BetM
I have a worksheet that contains a pivot table and data that users
input on each row based on the value of a cell on the pivot table.
How can this data keyed by the user be kept on the same row as the
cell it is being referenced to when the pivot table is refreshed?
For example, the pivot table contains:
Col1(name) Col(OrderAmt) User-Inputted Data on Col 3 (outside of
pivot table)
Company A $100 Company on Prohibited Payment List
Company B $50 Shipped 12/1/2003
$60 Company rep quit
Company C $800 company visit pending
Any help is appreciated. Thanks in advance.
input on each row based on the value of a cell on the pivot table.
How can this data keyed by the user be kept on the same row as the
cell it is being referenced to when the pivot table is refreshed?
For example, the pivot table contains:
Col1(name) Col(OrderAmt) User-Inputted Data on Col 3 (outside of
pivot table)
Company A $100 Company on Prohibited Payment List
Company B $50 Shipped 12/1/2003
$60 Company rep quit
Company C $800 company visit pending
Any help is appreciated. Thanks in advance.