pivot table change event

[kowalsky]

hi all,
i need some help on this problem, please.

I have a pivot table in a spreadsheet; in the same spreadsheet I have some ranges with some formulae - when the selection changes in the pivot table, those numbers change.
On a different spreadsheet I have some cells with numbers calculated with some VBA from the ranges in the spreadsheet with the pivot table - what code do I write and where do I put it so that when the pivot table changes selection my VBA code executes - the VBA code is in Module1 now,

thanks,
kowalsky

 

[noboffinme]

Hi kowalsky

I'd say you may need vba code that is triggered by an 'On Change' event.

Can I ask why you're not just using an Excel formula to update the data on the new spreadsheet considering you are already using an Excel formula for the change to the range numbers from your pivot table?

The pivot table would refresh, updating the ranges on the same spreadsheet & this would then be read by the data on the other spreadsheet.

You may have another reason why this must be done via VBA, an example file would be useful so I could see what you mean, Thanks