$$Excel-Macros$$ Re: Rota planning

2009-12-14 Thread Tonto
add afile. > > On Dec 14, 2:16 am, Tonto wrote: > > > > > Sheet did not attach - where do I do this please? > > > John- Hide quoted text - > > - Show quoted text - -- -- Some im

$$Excel-Macros$$ Re: Rota planning

2009-12-13 Thread Tonto
Sheet did not attach - where do I do this please? John -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials

$$Excel-Macros$$ Re: A question

2009-12-13 Thread Tonto
http://office.microsoft.com/en-us/templates/CT101172771033.aspx Plenty to go at here to get you started, John On 12 Dec, 18:13, hemant shah wrote: > Hi Team > > Can you pls help me with my question. > Every thing is mentioned in the attached sheet. > > Pls help, > > Regards, > > Hemant Shah > >

$$Excel-Macros$$ Rota planning

2009-12-13 Thread Tonto
Dear Group, I am looking to develop a duties rota writing spreeadsheet which creates a table based the rotataion of people but also taking notice of their ability to do either task. In the attached sheet I have listed and numbered all staff and set entry data for the size of the rota and the skil

$$Excel-Macros$$ Re: excel 2003, imsqrt not work

2009-11-05 Thread Tonto
http://office.microsoft.com/en-us/excel/HP052091331033.aspx If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. John On Nov 5, 2:32 pm, eric wrote: > dear ms excel experts: >   my name is eric lin, I had ms excel 2003, but when I open

$$Excel-Macros$$ calculate days from a range of dates.

2009-08-05 Thread Tonto
I am assessing how many days poeple have off sick and have a sheet to record this as follows. cola Date_off colb Date_ret colc Total days (networkday between off and ret) Does anyone have an idea how I can calculate in column colc how many days a person hs been absent in the previous 6 mont