Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi there,
I would like to create a calender in excell. I want it to look like an ordinary calendar (1 month per page) we have 6 employees and they all work a rotation of 6 on 3 off. I want to be able to enter formulas so that the calendar becomes perpetual and I don't have to do them manually on a monthly basis. I am hoping not to have to buy additional software. Thanks for all your' help, Sue |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Its not a simple task and excel is hardly better than a paper and a pen
when it comes to this unless you use VBA http://blog.jausovec.net/ if you go there, then click at the files link there is a template for creating work schedules, should probably work for at least excel 2000-2003 -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "suzyg23" wrote in message ... Hi there, I would like to create a calender in excell. I want it to look like an ordinary calendar (1 month per page) we have 6 employees and they all work a rotation of 6 on 3 off. I want to be able to enter formulas so that the calendar becomes perpetual and I don't have to do them manually on a monthly basis. I am hoping not to have to buy additional software. Thanks for all your' help, Sue |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i create a short cut on my desktop for a excell file? | Excel Discussion (Misc queries) | |||
How do i Use Excell to create a stem and leaf diargram? | Excel Discussion (Misc queries) | |||
How do I create a daily spending spreadsheet in Excell? | Excel Worksheet Functions | |||
How do I create project schedule using excel - office 2000 | Excel Discussion (Misc queries) | |||
how do I create a drop down menu in Excell? | Excel Worksheet Functions |