Create a Pivot Table from Advanced Filtered Data

[jvanbonn]

Does anyone know how to create a Pivot Table from a data set that is Advanced Filtered & Dynamic? Ideally, I'd like the PT to be able to update every time the filtered data is updated.

Any thoughts or suggestions?

Can I Trigger a PT refresh from a Private Sub Worksheet_Change(ByVal Target As Range) where the Target is from a different worksheet?

Excel 2007

 

[pbornemeier]

Have a command button on the data worksheet trigger code to:
Delete the temp worksheet.
Delete the PT worksheet that was based on the temp worksheet.
Create a blank temp worksheet
Copy filtered (e.g. visible) data (including headers) to the temp worksheet
Create the pivot table from the temp worksheet.
Manipulate PT in the standard way.

 

[jvanbonn]

Thanks Phil!

I'll give this a try.