Macro to copy above row and insert copied row based on value

[sambuka]

I am looking for a macro that will look for a value in column P ("ADD") and copy the row above and insert copied cells down below the copied row.

This will have to be looped until there are no remaining instances in that column.

[sambuka]

I have this for Delete of rows based on value:

Please Login or Register  to view this content.

[patel45]

try this

Please Login or Register  to view this content.

[sambuka]

Thats almost it. It loops through once, but needs to keep looping back through until no "ADD"s

For example: in my file, delete rows 8 and 9. Run the macro - it performs for the first, but as you can see with my formula in the cell, there is still an "add" in the column.

I need to keep looping through until all rows are copied down and the "add" is gone.

[patel45]

eliminate

Please Login or Register  to view this content.

[sambuka]

That worked. Thank you for your help!