Macro to insert column and include relative formulas from the column on the right

  • I need to create a macro to insert a double column to the left of the orange double column each year to show price increases so the customer can update their prices each year. I've been using auto fill and then going down each row to adjust the formulas.
    I want the formulas to update each time a new column is created so all that would need to be adjusted are the values and percentages in rows 2 and 3. There are at least 5 different formulas within the column. How do I do this so the formulas are copied but updated so the column numbers are automatically adjusted so the formulas work each year. Attached is the workbook [ATTACH]n1194468[/ATTACH] . I need to make sure the new columns are to the left of the orange column and to the right of the "Joy part numbers". Please help. I'm stumped at the moment. :smash:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!