Add new column after condition

clients sent me a sheet that have a table from Week 1 to week 13 (13 column) some clients doesnt, for exemple just for 12, 11 weeks
i want a macro to check if there is 13 column if not add new column in specific place

Please Login or Register  to view this content.

for the emplacement where i will add the column, it's dynamic, for example, if one client sends me a table with 12 weeks the headers will be, 1,2,3....12 in this case the new column will be added in the last , but another client send me a table like 1,2,4....13 so the new column should be added in the third place
any idea how to make this solution, and thank you

I can get something working for you with an example workbook.

i just upload my file