I have an Excel 2007 worksheet with a limited amount of personnel data n it.
I want to automatically generate additional rows of identical data but with a
different name (or character in the name) of the email address and/or the
last name in each successive row. The object is to take a limited amount of
data and create a larger population size in order to have more data with
which to work in a test database.

Here's a sample worksheet:


EMAIL LNAME FNAME ORG
DOA JOHN ORG1
DOB JOHN ORG1
DOC JOHN ORG1
DOD JOHN ORG1
DOE JOHN ORG1
DOF JOHN ORG2
DOG JOHN ORG2
DOH JOHN ORG2
DOI JOHN ORG2
DOJ JOHN ORG2

Thanks much.