Hi, I was looking similar sheet where we can calculate productivity and attendance of individual employee.
If any on has information please let me know. Many Thanks, Prashanth On Tue, Mar 31, 2009 at 6:28 AM, Norman May <nor...@gmail.com> wrote: > Ankur, > > Here is a link to an attendance sheet I made. > I'm not sure it will do what you want. > > http://www.scribd.com/doc/6078466/Attendance-History-091708 > > Norman > > On Mon, Mar 30, 2009 at 2:42 PM, ankur lodha <ankurlod...@hotmail.com>wrote: > >> >> hi everyone >> >> i've a task to prepare an attendance register of 10 candidates at my >> office.. i'm stuck in pivot table formation.. I'm attaching the sheet for >> your perusal.. >> >> I want name of candidates in rows.. present / leave / comp off / holiday >> being the column header and count of presents / leaves .. etc. pertaining to >> each in data field.. >> >> eg: >> present leave holiday comp off >> names count of each >> >> >> Please help.. >> >> >> ankur lodha >> >> ------------------------------ >> So many new options, so little time. Windows Live >> Messenger.<http://www.microsoft.com/india/windows/windowslive/messenger.aspx> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
