Looping to new row and copying and renaming worksheets

[Jeannine]

I am not great with Excel macros, but I am looking to try to mimic the
Word Mail Merge concept in Excel. Basically I have a list of rows
with three pieces of information. Example below of this list format:

Name Emp # Vacation Hours
John Smith 24535 200
Bob Jones 22452 360
Jane Martin 35256 140

Then I have another template worksheet in another file that has empty
fields that should be populated with the values from the previous
list. I want to create a unique worksheet with the information for
each record above. Each worksheet should be called the value in the
name field and the following fields would be populated uniquely on
each worksheet

Name goes to E1 on the copied worksheet
Emp # goes to G2 on the copies worksheet
# in Vacation Hours goes to I66
I want the Worksheet to be renamed to match the value in the name
field

So I would end up with the template which is blank and 3 new
worksheets with each individuals name on it, but I either can't get it
to loop correctly or rename the worksheet.

Any help would be much appreciated.
Thanks,
Jeannine

 

[David McRitchie]

Hi Jeannine,
You did not show your code, but the most complicated part
would be to reference the original sheet and the new sheet
on an assignment statement. See if this example helps

http://www.mvps.org/dmcritchie/excel/code/bus_sched.txt

some additional code snippets in
http://www.mvps.org/dmcritchie/excel/sheets.htm