Excel Template Question...


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
 
Ad

Advertisements

A

Auric__

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?

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?

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

Advertisements

D

d

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.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top