Automatically Creating Worksheets
 

I'm VERY new to this so I hope this makes sense, and really hope tha
someone is able to help.

I currently have a workbook that contains 2 sheets, the first is calle
"List" (and contains a list of employees in my team from cell rang
b4:b25), the second is called "master" and is a standard form that wil
in the future contain performance statistics for each memeber of m
team.

What I would like to do each week is paste an up to date list of tea
members into the "list" worksheet, and have excel create an appropiatt
number of copies of the "master" sheet. i.e. if there are 18 people i
my team this week then 18 copies of the master sheet will be created.

Secondly I would like each new master sheet to have the name of eac
employee populated in cell c4, as well as renaming the sheet with th
same name.

i.e. cell b4 on the "list" sheet contains the name "Jo Bloggs", one o
the copies of "master" would be named "jo Bloggs" and have the name i
cell c4. cell b5 on the "list" sheet contains the name "Chri
Williams" and so another copy of the "master" sheet would be rename
"Chris Williams" and have that name in cell c4 and so on...

Any help at all would be much appreciatted.

Regard

--
Papa Waig
-----------------------------------------------------------------------
Papa Waigo's Profile: http://www.excelforum.com/member.php...fo&userid=3607
View this thread: http://www.excelforum.com/showthread.php?threadid=55860

Automatically Creating Worksheets
 

Sub newsht()
Do While Sheets("List").Range("B4").Offset(i, 0).Value < ""
Sheets("Master").Copy After:=Sheets("Master")
ActiveSheet.Name = Sheets("List").Range("B4").Offset(i,
0).Value
Range("C4").Value = Sheets("List").Range("B4").Offset(i,
0).Value
i = i + 1
Loop
End Sub


--
lcoreyl
------------------------------------------------------------------------
lcoreyl's Profile: http://www.excelforum.com/member.php...fo&userid=2042
View this thread: http://www.excelforum.com/showthread...hreadid=558609

Automatically Creating Worksheets
 

That really is fantastic, Thank you!!

What if I wanted to remove any formulae from the created sheets, and
just leave the values behind?


--
Papa Waigo
------------------------------------------------------------------------
Papa Waigo's Profile: http://www.excelforum.com/member.php...o&userid=36074
View this thread: http://www.excelforum.com/showthread...hreadid=558609