View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
d d is offline
external usenet poster
 
Posts: 1
Default Excel Template Question...

Hello all,

I have inherited a new job which requires timekeeping/payroll via excel
for 125 employees. There is a template on the first worksheet which I
must change monthly and then copy and paste to each employee page. It
will save so much time monthly, as I have to manually enter the times
already.

I need to find out the following, if it is possible:

1)Is there a way to set up each employee's page so when the template
changes, then all employee pages change?

2) When a new employee is created, is there a way to auto create their
sheet from or to the template and the 'Master Employee' list?

TIA... SS