Here's the problem:

Sheet is 20 columns by 1,000 rows. Column B contains 1,000 names. I want to
search for a name. When found, I want to duplicate the row in which the name
was found. Then I want to change one value in that row (in column D).

I want to repeat this operation for many names.

Any ideas?