Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
![]()
Posted to Programming to get a faster reply.
"lj" wrote in message oups.com... I have the following formula that I use in visual basic to update a pivot table from a pivot table. I want to alter the formula to update a pivot table from a set of data (that was brought in from a query to excel). How do I alter my formula below? Sheets("Commissions").Select ActiveSheet.PivotTableWizard SourceType:=xlPivotTable, SourceData:= _ "[Munge_Report.xls]Data!Query" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Visual Basic Question | Excel Worksheet Functions | |||
visual basic coding question | Excel Discussion (Misc queries) | |||
Visual Basic Question | Excel Discussion (Misc queries) | |||
Visual Basic Mail Question | Excel Programming | |||
Visual Basic Question | Excel Programming |