View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DMithias
 
Posts: n/a
Default Add a button to refresh a pivot in another tab of the same workbook


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


--
DMithias
------------------------------------------------------------------------
DMithias's Profile: http://www.excelforum.com/member.php...o&userid=31322
View this thread: http://www.excelforum.com/showthread...hreadid=510188