Find, copy, create a row under, paste, loop.

Closed
Dawid - Jan 26, 2015 at 10:43 AM
Hello,

I would like to ask for a macro (as I was unfortunate to experiment with a lot of them and none of them worked as I'd like).

What it should do is to look for 2 values in separate columns (Column D = 2 and Column E=92) to match in the same row, create exactly the same row with the exactly same data in it (except for the value 92 from the column E, this should change to 93) BELOW the row that has D=2 and E92 and start to search another match and repeat the process in the same sheet for other matches.

I hope It was clear enough. Thanks for the help!