Excel Template Question...

  • Thread starter Thread starter d
  • Start date Start date
D

d

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
 
d said:
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?
Click to expand...

Probably. More info would help, but it could be as simple as "=Sheet1!A1" or
similar. (Depends on what info is being changed and how it's used, of
course.)
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?
Click to expand...

Create a blank employee sheet with all of the appropriate information on it,
name it something like "New Employee Template", and hide it. (Right-click on
the sheet's tab and select "Hide".) When you need to make a new employee
sheet, unhide the template (right-click on any sheet's tab and select
"Unhide...", then pick the template), copy it, and then rehide it. Fill in
the blanks.
 
Auric__ said:
Probably. More info would help, but it could be as simple as "=Sheet1!A1" or
similar. (Depends on what info is being changed and how it's used, of
course.)


Create a blank employee sheet with all of the appropriate information on it,
name it something like "New Employee Template", and hide it. (Right-click on
the sheet's tab and select "Hide".) When you need to make a new employee
sheet, unhide the template (right-click on any sheet's tab and select
"Unhide...", then pick the template), copy it, and then rehide it. Fill in
the blanks.
Click to expand...

Auric,

Thank you for the response. Now with the clarification (I trust), there
are sections of the spread sheet which change monthly, i.e. pay periods,
which need to be updated for each month before moving forward.

For example, currently I Am working on February's pay period. Each
period is the 15th and last day of the month. As such, once I have
finished or even possibly before, create a workbook for the next month
or even several months in advance, time permitting.

Currently, I have to change each worksheet for each employee every
month. This is in addition to the real detail work of posting the hours.

Thus, my question is, using the section of the current template for the
current pay period (which requires updating monthly to reflect the
current months pay periods)from which a copy/paste function is used now.
I would like to just update the template and have each worksheet auto
update to reflect the changes made in this part of the worksheet only.

I will have to manually enter the hours, which is fine. But to have to
modify each worksheet for each month is a time-killer.

Thank you for your input and insight.

Warmest - SS
 
Back
Top