| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add a button to refresh a pivot in another tab of the same workbook
This macro is cool, D. It refreshes the pivot table whenever you click on
the worksheet on which it resides. http://vbaexpress.com/kb/getarticle.php?kb_id=80 Perhaps that will work for you. ************ Hope it helps! Anne Troy www.OfficeArticles.com Check out the NEWsgroup stats! Check out: www.ExcelUserConference.com "DMithias" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table using different worksheets/same workbook | Charts and Charting in Excel | |||
| Copying a button with code into another workbook | Excel Discussion (Misc queries) | |||
| Excel Pivot tables refresh | Excel Worksheet Functions | |||
| Refresh all pivot tables in a workbook | Excel Discussion (Misc queries) | |||
| Pivot table Data refresh | Excel Worksheet Functions | |||
Threaded Mode
