VBA Code to Copy current row and insert below based on a cell value being greater than zero

[Scottyp123]

I have rows 12 through 255 in a worksheet that I want to copy if the value in column G is > 0 and insert the row below that row. I would like this newly created row to be removed if the value in G is put back to zero. If possible I would like to have it limit the creation of the same row to 4 times. Any help would be greatly appreciated.

 

[RoryA]

This is a duplicate thread. Please don't post the same question more than once.

Thread closed.