Ron,

That gave me the results I need, but is there a way to make a pivot
table stay active so every time you change the data entered, it would
make the changes to the final table? I'll be entering new data
constantly and trying to have the results without doing manual
operations.

Thanks for your help.

Travelersway


--
travelersway
------------------------------------------------------------------------
travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623
View this thread: http://www.excelforum.com/showthread...hreadid=389628