L
Lenardz
Hi,
Is there a way for me to put the datasource,sheet and range information in a
cell, then reference the PivotTable to that cell to get the information?
I have 3 PivotTables and would like to be able to access between current and
historical data without having to go through the manual process of:
- Starting the wizard
- Click back
- Update the datasource
- Click OK
All datasources are exactly the same, except for the workbook name.
Any ideas?
Is there a way for me to put the datasource,sheet and range information in a
cell, then reference the PivotTable to that cell to get the information?
I have 3 PivotTables and would like to be able to access between current and
historical data without having to go through the manual process of:
- Starting the wizard
- Click back
- Update the datasource
- Click OK
All datasources are exactly the same, except for the workbook name.
Any ideas?