while Inserting new columns, formulas should remain intact

[aman-somal]

Hello, 

I have an excel sheet where formulas are applied from left to right. My boss wants that whenever he inserts a new column on the right side and mentions numbers,  automatically formulas take that values in columns, and automatically new relevant columns should insert on the left side also.

Please help.

Regards,

[#2]

@aman-somal 

With your permission, if I may recommend, add a file (without sensitive data) and use this file to describe your problem step by step, or add photos with the appropriate description.  

You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.

Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).

Don't forget no one in this forum can see what you see.

In this link you will find some more information about it:

Welcome to your Excel discussion space!

Thank you for your understanding and patience

NikolinoDE

I know I don't know anything (Socrates)