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

[Keers1]

I need help using macro in the pivot table filter. I have two pivot sheets, each should be refreshed and below auto-population needs to be done using a 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 on Feb 21, select Jan - 21.

Column "L2 " 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 "L2 " value to be populating correct month

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

Thanks for your help in advance.