Adding additional worksheets to an existing template
 

I have found a great template to calculate commissions for my employees.
This template is onlt one worksheet and I would like to have each emploee as
a seperate worksheet on the commission statement. Is there an easy way to
duplicate the template on each worksheet I add to the Excel Spreadsheet?
Thanks in advance for your help.

Adding additional worksheets to an existing template
 

Mike,

This could be accomplished with a small amount of code. You could basically
cycle through the employee list and add a sheet for each employee.
--
http://HelpExcel.com




"Mike F" wrote:

I have found a great template to calculate commissions for my employees.
This template is onlt one worksheet and I would like to have each emploee as
a seperate worksheet on the commission statement. Is there an easy way to
duplicate the template on each worksheet I add to the Excel Spreadsheet?
Thanks in advance for your help.

Adding additional worksheets to an existing template
 

I am not sure if I understand fully what you are trying to do. But, to
duplicate a sheet exactly without copying and pasting is:

Click and hold on the sheet tab at the bottom, press and hold the ctrl key
on the keyboard. Drag the tab to the right. the exact worksheet will be
duplicated. Rename the worksheet to the next users name. Repeat the game
until you have enough sheets for all users.
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


"Mike F" wrote:

I have found a great template to calculate commissions for my employees.
This template is onlt one worksheet and I would like to have each emploee as
a seperate worksheet on the commission statement. Is there an easy way to
duplicate the template on each worksheet I add to the Excel Spreadsheet?
Thanks in advance for your help.