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.

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
(E-Mail Removed)



"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.

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.