Pivot table: Adding dynamic columns
 

After creating a pivot I would like to add three columns besides th
'Total' column for adding some formulas and data that I shall pull fro
another w.sheet.
However, I need the added column ranges to be dynamic so that if th
source data for the pivot is changed, resulting in fewer/greater row
in the pivot, then the added 'external' columns will adjus
accordingly?

Even a couple of tips on how to refer to the 'Total' range would b
helpful as I'm fairly confident that I could work the rest out
although the whole sh-bang would, of course, be even better!


Thanks,

Adria

--
Message posted from http://www.ExcelForum.com