| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add a button to refresh a pivot in another tab of the same workbook
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. -- DMithias ------------------------------------------------------------------------ DMithias's Profile: http://www.excelforum.com/member.php...o&userid=31322 View this thread: http://www.excelforum.com/showthread...hreadid=510188 |
| Reply |
| 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 | |||
Linear Mode
