when specific text is entered in a cell add a new row below with formula as above row

[momad]

hi i am new to this forum. found some great solutions and thought of posting my specific issue. i am also very new to VBA.

i am creating a payment tracker table on excel. when a specific text is entered in either column' E, H or K like "Doc. Incomplete" i want to automatically insert a row below. but this row should also copy the formula from the existing rows.

Ex: Row 7 has multiple conditional formatting and formulas. if users enters Doc. "Incomplete" in E7 a new row (8) to be inserted copying all of Row 7's formatting and formula

in another thread i found a coding and modified it as follows

Please Login or Register  to view this content.

it does insert a row but not copy formula.

please help

Moderator's Note: As per Forum Rule #3, please use code tags…Thanks.

[patel45]

try this

Please Login or Register  to view this content.

[momad]

Patel45,
thank you very much. it works partially. while it does create a row below and copies formula, it also creates 8 copies of the row. and if i try it again it created 32 new rows.

not sure how this happens

thank you though appreciate your help

[patel45]

I'm sorry

Please Login or Register  to view this content.

[momad]

Patel45

Brilliant:
it worked. thank you so much.

Mo