csnakamura1
New Member
- Joined
- Feb 24, 2011
- Messages
- 1
I have a running pivot Table and update and refresh the data every month.
The rows tend to change. I would like to run a vlookup to the row data so when the data changes it will pick up the column data (on the far left of the Pivot). I do not want data in the actual pivot, otherwise I would use a getpivotdata. Any information will be greatly appreciated.
The rows tend to change. I would like to run a vlookup to the row data so when the data changes it will pick up the column data (on the far left of the Pivot). I do not want data in the actual pivot, otherwise I would use a getpivotdata. Any information will be greatly appreciated.
