Hi,
I used macros to create 3 different pivot tables in a one worksheet. I created a normal table which is a form of report whose calculations are based on the data from these 3 tables. Both these worksheets are in the same workbook.
I used GetPivotData to refer to these pivot tables in the calculations made in the normal table report.
Issue:
Before every time the macro creates these 3 pivot tables, it clears the worksheet. So, the normal table report is not automatically updating the reference to these pivot tables. The 3 pivot tables always have same range and they have pivot table names too.
Is there any way the table report form automatically picks up the newly created 3 pivot table references?
Kindly help! Thanks in advance
I used macros to create 3 different pivot tables in a one worksheet. I created a normal table which is a form of report whose calculations are based on the data from these 3 tables. Both these worksheets are in the same workbook.
I used GetPivotData to refer to these pivot tables in the calculations made in the normal table report.
Issue:
Before every time the macro creates these 3 pivot tables, it clears the worksheet. So, the normal table report is not automatically updating the reference to these pivot tables. The 3 pivot tables always have same range and they have pivot table names too.
Is there any way the table report form automatically picks up the newly created 3 pivot table references?
Kindly help! Thanks in advance