Paste Auto-Filtered Cell Total in New Worksheet

[aljiwani]

Hi there,

I have a worksheet with over 3000 cells of data. I'm trying to make a new summary sheet with product totals into a new sheet. However, when I do so, whatever filter I have filtered on changes the total in the Summary sheet.

for example:

I have filtered on all Widgets Version 2007 and copy the total from my data worksheet. I paste the total into the Summary tab.
Then I filter on all Widgets Version 2010 and when I go back to my Summary tab, my total is now all Widgets Version 2010 instead of 2007.
It keeps changing.

I can't paste just the values because the Data is constantly changing.

Any help is greatly appreciated. Thank you.