Adding additional worksheets to an existing template

  • Thread starter Thread starter Mike F
  • Start date Start date
M

Mike F

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.
 
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.
 
Back
Top