how to add a formula at the bottom of a pivot table?
 

Hello,

I have created a pivot table on the sheet "TP_REPEAT" using VBA (pleas
have a look at my code)

I would like to add automatically (and not manually indeed) a formul
'standard deviation' at the bottom of this table. The position of th
row where you can find these formulas change with the number of day
(see cell B3 on sheet "Intro"). For instance, in the attached file
It's row 14..also equal to the number of days+4

What could I do?

Thanks a lot by advance

Regards,

Françoi

--
frad
-----------------------------------------------------------------------
frade's Profile: http://www.excelforum.com/member.php...fo&userid=2297
View this thread: http://www.excelforum.com/showthread.php?threadid=46721