Copy formula in new rows automatically

[Rahul15292000]

Hi Friends,

I have couple of rows with formula (e.g IF nested statements, VLOOKUP etc). But when the user insert a new row, these formulas are not copied automatically into the new row.

How can I have the formula copied into new row automatically

[6StringJazzer]

Convert the range to a Table. Highlight the data (including headers) and click Insert, Table, and check My Table Has Headers.

[Rahul15292000]

Thanks Jeff. This worked buddy!!

[6StringJazzer]

Glad to hear it! Thanks for the rep!

[Rahul15292000]

Hi Jeff, the following solution provided by you worked, but when I protect the sheet, it does not work.

"Convert the range to a Table. Highlight the data (including headers) and click Insert, Table, and check My Table Has Headers."

Kindly advice how can I make this solution work when the sheet is protected.

[AliGW]

Select the table - right click - format cells - protection - make sure that the locked box is unticked (unchecked).

Now, when you pritect the sheet, make sure that you tick insert rows.

Now it should work OK when the sheet is protected.

[Rahul15292000]

Hi Ali,

I did the same as advised by you, but still the formula do not copied down atomically. In the screenshot , I inserted a new row 8 and I have formula in Col A and Col T. So cell A8 and T8 shod have formula copied down. But it is not working after I protect the sheet.

Attachment 620321

[AliGW]

Out of ideas - sorry.