| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Pivot Table Range
G'Day All,
I have a workbook that has a Worksheet containing raw data read from an Access database using VBA/ADODB using criteria selected from a UserForm. Several other Sheets contain summary reports of various kinds assembled from the Raw Data using VBA. I would like to construct two Pivot Tables/Charts based on the Raw Data. How may I update the underlying range of these, when the raw data range changes from time to time depending on the criteria? -- Regards, Pat Garard Melbourne, Australia _______________________ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can i change pivot table to change data | Excel Discussion (Misc queries) | |||
| change range for pivot table on refresh | Excel Discussion (Misc queries) | |||
| Change the range of a pivot table data source | Excel Programming | |||
| Macro to change a Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table/ % Change | Excel Programming | |||
Threaded Mode
