Generate a code that changes automatically every month

Hi Everyone,

I have a page with a pivot table followed by a table right next to it that refers to cells on the pivot to calculate outputs. However every month when I refresh the pivot table, it extends one column to the right and if I don't insert a column in between the pivot and the table next to it I created, the pivot would overwrite first column of the table. Below I have created a code that will search for the first column of the table I have created and then inserts a column in between the Pivot table and the Table.

My question is how can I make this continuous without me having to copy and paste the 'If then statements' and having to change the reference column every time? (Keep in mind I will have to keep updating the Macro). I also included a picture. Thanks in advance!

**By the way I am new to the forum, hope I posted in the right section.

Please Login or Register  to view this content.

excel capture.PNG

TMS much thanks. It works perfectly !!