Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Monthly Accruals
Each month I enter OT accruals, Holiday, etc for each employee. I make a
copy of the Master List with all the formulas and names each month and then enter the information for that month. Is there an easier way of doing this so I can just input new amounts every month without making a copy of the Master List? (Each worksheet is linked to the previous month so we have a running total, but I have to link them to the Master List) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Monthly Accruals
It's not clear what you want. Is the "Master List" a sheet name?
You say "...just input new amounts every month without making a copy of the Master List?" Where do you want to enter these "new amounts"? Into the Master List sheet? That presupposes that the information previously entered into the Master List sheet will be transferred to some place else, or lost. Are my questions making any sense or am I just missing something? Generally, anything you do repetitively Excel can do for you. Please post back with a clearer explanation of what you have and what you would like to have. HTH Otto "gem58" wrote in message ... Each month I enter OT accruals, Holiday, etc for each employee. I make a copy of the Master List with all the formulas and names each month and then enter the information for that month. Is there an easier way of doing this so I can just input new amounts every month without making a copy of the Master List? (Each worksheet is linked to the previous month so we have a running total, but I have to link them to the Master List) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Monthly Accruals
The Master Worksheet is a name. In this "Master List" I have calculations
for Overtime, Holiday Accruals (e.i. Smith gets 2.33 days vacation per month, 1.5 hours for OT and sick time at 1.25 hrs per month) Because those accruals don't change every month I just copy it to another worksheet every month and create a new name e.i. June 2006 and link the worksheets to the total accruals at the end of the previous month i.e. May 2006. (Nothing is linked to the "Master List" I just use it as a template.) "Otto Moehrbach" wrote: It's not clear what you want. Is the "Master List" a sheet name? You say "...just input new amounts every month without making a copy of the Master List?" Where do you want to enter these "new amounts"? Into the Master List sheet? That presupposes that the information previously entered into the Master List sheet will be transferred to some place else, or lost. Are my questions making any sense or am I just missing something? Generally, anything you do repetitively Excel can do for you. Please post back with a clearer explanation of what you have and what you would like to have. HTH Otto "gem58" wrote in message ... Each month I enter OT accruals, Holiday, etc for each employee. I make a copy of the Master List with all the formulas and names each month and then enter the information for that month. Is there an easier way of doing this so I can just input new amounts every month without making a copy of the Master List? (Each worksheet is linked to the previous month so we have a running total, but I have to link them to the Master List) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Monthly Accruals
hello, You can define a seperate area for data input for monthly accruals ( one col for each month) and then use INDEX function to pick data from there into a pre defined report format. Hope it'll work regards O. gem58 Wrote: Each month I enter OT accruals, Holiday, etc for each employee. I make a copy of the Master List with all the formulas and names each month and then enter the information for that month. Is there an easier way of doing this so I can just input new amounts every month without making a copy of the Master List? (Each worksheet is linked to the previous month so we have a running total, but I have to link them to the Master List) -- odysseyoflife ------------------------------------------------------------------------ odysseyoflife's Profile: http://www.excelforum.com/member.php...o&userid=35339 View this thread: http://www.excelforum.com/showthread...hreadid=550462 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert irregular data to monthly equivalent? | Excel Discussion (Misc queries) | |||
monthly meeting attendance log in excell | Charts and Charting in Excel | |||
INVESTMENTS OPPORTUNITES: Get 10.5% or 50% Monthly returns | Links and Linking in Excel | |||
Updating links monthly... | Excel Worksheet Functions | |||
spread sheet template for monthly business for a year | Excel Discussion (Misc queries) |