Insert new column when "average" found in row 3

[Buddy7]

This code inserts a new column to the left of Column CV

Please Login or Register  to view this content.

I am looking for assistance with this code. I am wanted to modify it so it will scan Row 3 for the contents “Average”. When those contents are found in a column in Row 3, the code will insert a new column to the left of that column. In other words whatever column in Row 3 that contains the contents “Average” a new column will be inserted to the left of that column. Can you help?

[Leith Ross]

Hello Buddy7,

Here is a macro to insert a new column whenever any cell in row 3 equals "average".

Please Login or Register  to view this content.

[stanleydgromjr]

Buddy7,

Try:

Please Login or Register  to view this content.

Then run the "FindInsertColumn" macro.

[JBeaucaire]

Like so:

Please Login or Register  to view this content.

[Buddy7]

Leith Ross, thank you for your help. I appreciate your input very much.

[Buddy7]

Stan, I appreciate your help very much. Thank you for your feedback.

[Buddy7]

JB, thanks man. This works very very well. I am grateful for your help.