Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Template Question...
d wrote:
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. -- I abstained from evil and I was ultimately vindicated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Template Question...
Auric__ wrote:
d wrote: 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. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Template(s) Question | Excel Programming | |||
Excel Template Question | Excel Discussion (Misc queries) | |||
Template question - can I replace the default "worksheet" template | Excel Discussion (Misc queries) | |||
Excel 2002 Master Template Question | Excel Discussion (Misc queries) | |||
Template question | Excel Discussion (Misc queries) |