Help inserting rows with correct formulas and conditional formatting

[jenlp]

Hello,

I am looking for some assistance please with a spreadsheet I am currently developing.

Each row in my spreadsheet represents a unique job and has a number of formula and conditional formatting behind it which I drag across the row to autofill all relevant cells (because of this horizontal autofilling many of the cell references in my formula are absolute).

I have created a macro which inserts a row at the top of the spreadsheet and correctly inserts all the different formula and conditional formatting. My issue is that the user wants to be able to manually insert rows at any place in the spreadsheet. When this occurs, the formula in the rows do not copy down into the new row and the conditional formatting goes haywire for both the new row and the one it was inserted above.

I am thinking that my best course of action may be to create an InsertRow macro but am not really sure how to put it all together.

Any assistance would be greatly appreciated.

Many thanks in advance.
​

 

[svkroy]

Hello,

I am looking for some assistance please with a spreadsheet I am currently developing.

Each row in my spreadsheet represents a unique job and has a number of formula and conditional formatting behind it which I drag across the row to autofill all relevant cells (because of this horizontal autofilling many of the cell references in my formula are absolute).

I have created a macro which inserts a row at the top of the spreadsheet and correctly inserts all the different formula and conditional formatting. My issue is that the user wants to be able to manually insert rows at any place in the spreadsheet. When this occurs, the formula in the rows do not copy down into the new row and the conditional formatting goes haywire for both the new row and the one it was inserted above.

I am thinking that my best course of action may be to create an InsertRow macro but am not really sure how to put it all together.

Any assistance would be greatly appreciated.

Many thanks in advance.
​

Go ahead create an Insert Row macro and at the end of it call the conditional formatting macro to oversee the formatting aspects. To restrict users from hitting Ctrl+ to insert rows, disable this function using "Application.OnKey" method.