You can't make a Pivottable update everytime something happens (unless
you use some VBA-code).
But you can often make the same 'Pivottable layout' by using formulas.

HTH
Ola


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=379010