Hi p45cal,

Thanks for the updated code but still one thing is missed. Can you please check below and confirm?

Also Please confirm whether refresh of those pivots individually been included in your code. If not i need to update the code for the same.

sheet -> "Item-Pen Set

Pivot 2- refresh the pivot and if we are in 12th month select 1 to 11th month value and if we are in feb 21, select only jan 21 month

Column "L2 " value to be populating correct month.