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

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.

I have this for Delete of rows based on value:

Please Login or Register  to view this content.

try this

Please Login or Register  to view this content.

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.

eliminate

Please Login or Register  to view this content.

That worked. Thank you for your help!