RE: Pivot filter Month selection - Automatic Population in respective column

[Keerthi@21]

Dear all,

I need an help using macro in pivot table filter. I have two pivot sheets, each should be refreshed and below auto population needs to be done using macro. Attached the excel data file for your reference.

sheet -> "Item-Pencil " - Pivot 1- refresh the pivot select the Month to previous Month i.e. if we are 12th month select 11th month and if we are in feb 21, select Jan - 21. Column "A2 " value to be populating correct month sheet -> "Item-Pen set" Pivot 2- refresh the pivot select the Month to previous Month i.e. if we are 12th month select 11th month and if we are in feb 21, select Jan - 21. Column "B2 " value to be populating correct month

Once respective columns updated, save the macro file and exist.

Thanks for your help in advance.