Change Pivot Data Source per cell.

[Tapyr]

Hi team,

I am not sure if it is technically possible or not, but let me try to explain my request.

I have 2 sheets with 2 tables with same columns.
1st sheet called Data1 contains table named: TableData1 and 2nd sheet called Data2 contains table: TableData2.

As you can see in attached Example file, in sheet Data2 you can see data for CURRENT MONTH. However this identificator is variable and can be change to PREVIOUS MONTH and Data1 will be CURRENT MONTH.

My point is to ensure, that Pivot table in sheet PIVOT will somehow change Source to data from sheet where CURRENT MONTH is identified.

Thank you in advance for any help and advise.