If name appear in column write x amount of rows with same information

Hi,

I'm new to VB so forgive me if my questions are too simple.

What I'm trying to do is search only column D and if it has specific words like "old" or "new" then I would like it to make a copy of that row and place it below. It doesn't have to be directly below. If the column contains the word "renew" then paste that row twice below.

Also, if the column D has the word "open" then write 1, 2, 3, 4 in the columns next to it, I have started with this below:

Please Login or Register  to view this content.

Thanks for any help,

David