maclachlan
New Member
- Joined
- Dec 28, 2005
- Messages
- 32
I have a pivot table that uses columns A to D. I have added a button using code that updates the pivot table. Columns E and F contain a vlookup formula that is based on column D of the pivot table. The pivot table will grow and shrink upon updating and I need the formula to do the same.
I think there must be a way using some code to look and see if the cell in column D contains data then the formula is copied to columns E and F. I would like the formula to copy down the entire column each time the pivot table is updated. This will make sure a fresh formula is created each time.
Thanks
Rob
I think there must be a way using some code to look and see if the cell in column D contains data then the formula is copied to columns E and F. I would like the formula to copy down the entire column each time the pivot table is updated. This will make sure a fresh formula is created each time.
Thanks
Rob