Automating filtered totals

**Andy Pope** · 10-12-2010, 10:11 AM

Try this example pivot table

**flux88** · 10-12-2010, 10:28 AM

Thanks that is exactly what I want.

However when I copy and paste my data and extend to helper cells the pivot chart doesnt update?

**Andy Pope** · 10-12-2010, 10:32 AM

Would not expect it to either.

You need to use the Pivot wizard to step back and adjust the range being used, you can then refresh the table.

You can use a dynamic range as the data source if you set it up.

PTDATA: =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1))