Without seeing the workbook, something like

for each n in range("yournamelist")
sheets("Template").copy after sheets(sheets.count)
with activesheet
.copy items from master sheet
end with
next n

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
Good day all,

I am an Excel novice and would really appreciate assistance in regard
to the following:

I have a worksheet with employee names and employee no's each with
specific information per row.

I would like to have a worksheet created for each employee and have
specific information from the main worksheet to show on each worksheet
e.g. Employee name, Empl No., Basic salary etc. The created worksheets
then needs to do specific calculations e.g. % increase, basic montly
medical aid contributions, etc. I have already created the worksheet
which does all the calculations but have to now duplicate it for each
employee and insert each employee's specific information (more than
500 employees!). Is there a way in Excel or VBA in which this can be
done quicker and/or automatically? (please keep in mind I'm not an
expert in Excel or in VBA and would thus need a detailed explanation)

Thank you kindly!


Rennier