Add a button to refresh a pivot in another tab of the same workbook

  • Thread starter Thread starter DMithias
  • Start date Start date
D

DMithias

Ok... I'm just beginning to learn how to use macros so please be kind.


I have a report that pulls totals from a pivot table on another tab
using a vlookup. I want to add a command button on the report tab that
I can click and refresh the pivot table on the other tab.

If anyone has some good code for this or else can point me to a good
source it would be much appreciated.

-DM
 
Thanks Anne. It worked. Still, though, there is something satisyfing
to actually seeing the information change when you hit refresh. If you
happen to run across something similar that would be great. In the
meantime, thanks for the info, it is handy.
 
Back
Top