Good and I also like the concept / funda of defined names. -- Thanks & Regards,
DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Tue, Mar 9, 2010 at 1:22 PM, Born to Win <cs4...@gmail.com> wrote: > Sir, > > Please Check Attendance Tracker. > > > Thanks For ur Motivation. > Regards > chandrabhan Singh > +919711535271 > > > > > On Thu, Mar 4, 2010 at 11:27 PM, Dilip Pandey <dilipan...@gmail.com>wrote: > >> Hi, >> >> I have checked and I do not have a readymade Attendance Tracker available >> with myself. Please try to build up the tracker by your own and let the >> "Group" know if you face any challenge(s). >> >> -- >> Thanks & Regards, >> >> DILIP KUMAR PANDEY >> MBA-HR,B.Com(Hons),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 62, India >> >> >> On 3/4/10, Prabhat kumar <cs4...@gmail.com> wrote: >>> >>> FYI >>> >>> Regards >>> chandrabhan Singh >>> +919711535271 >>> >>> >>> >>> >>> On Thu, Mar 4, 2010 at 5:43 PM, Prabhat kumar <cs4...@gmail.com> wrote: >>> >>>> Hello Group, >>>> >>>> any one have format for HR(Leave tracker format). >>>> >>>> Please send me. >>>> >>>> >>>> >>>> Regards >>>> chandrabhan Singh >>>> +919711535271 >>>> >>>> >>>> >>>> >>>> On Mon, Mar 1, 2010 at 5:08 PM, Prabhat Kumar m...@ff@rPur/Delhi < >>>> cs4...@gmail.com> wrote: >>>> >>>>> Hi group< >>>>> >>>>> Please give me a format for Leave Tracker.its urgent need. >>>>> >>>>> Thanks Looking in to my Query. >>>>> Regards >>>>> chandrabhan Singh >>>>> +919911255330 >>>>> >>>>> >>>>> >>>>> >>>>> On Sat, Feb 27, 2010 at 1:45 AM, Prabhat Kumar m...@ff@rPur/Delhi < >>>>> cs4...@gmail.com> wrote: >>>>> >>>>>> Dear sir, >>>>>> >>>>>> I have a new Challenge to Maintain Leave Records of Employee in my >>>>>> Company.First of all i want to share some information about >>>>>> Leave Policy. >>>>>> >>>>>> All employee who's Tenure is 6 Months or more is Eligible to take 9 >>>>>> Annual Leave & Apart from Week offs Employee can Take 1 casual Leave each >>>>>> month.Over all 18 Al in a Year & 12 CL. >>>>>> >>>>>> But In case of CL:-if Employee is not able to take his/her casual >>>>>> Leaves within 3 Months. his/her CL will expire.we can't carry forward his >>>>>> leave in Next Month. >>>>>> >>>>>> In case of AL:-After every 6 months Employee can Take 9 Als >>>>>> if Employee is not able to take his/her Als with in 2 Year >>>>>> Including Current Year then his Al will Expire. >>>>>> >>>>>> Please Find Attached Leave Tracker for Reference. >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> Happy holi for u & ur Family & for Lovely group. >>>>>> >>>>>> >>>>>> Regards >>>>>> chandrabhan Singh >>>>>> +919711535271 >>>>>> >>>>>> >>>>>> wrote: >>>>>> >>>>>> Dear Chandrabhan, >>>>>>> >>>>>>> If this is not late, I would expect you to send a dummy test file and >>>>>>> let me give a try on this. While sending the test file, be specific >>>>>>> what >>>>>>> you want as an outcome. If possible, try to provide the snapshot of the >>>>>>> expected result as well. >>>>>>> >>>>>>> -- >>>>>>> Thanks & Regards, >>>>>>> >>>>>>> DILIP KUMAR PANDEY >>>>>>> MBA-HR,B.Com(Hons),BCA >>>>>>> Mobile: +91 9810929744 >>>>>>> dilipan...@gmail.com >>>>>>> dilipan...@yahoo.com >>>>>>> New Delhi - 62, India >>>>>>> >>>>>>> >>>>>>> On 2/8/10, chandrabhan singh <cs4...@gmail.com> wrote: >>>>>>>> >>>>>>>> Dear Andy, >>>>>>>> >>>>>>>> Please do a favor for me could you make this on excel Sheet with VB >>>>>>>> programming.one sheet would be data base & second Sheet would >>>>>>>> be Snapshot where i can select Team Leader's name by Validation >>>>>>>> & it will calculate Absent ism & Shrinkage(%) of that Team Leader >>>>>>>> Itself. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Sun, Feb 7, 2010 at 2:57 PM, Aindril De <aind...@gmail.com>wrote: >>>>>>>> >>>>>>>>> Hi Chandhrabhan, >>>>>>>>> >>>>>>>>> Your query might be a little misplaced as it is a forum mainly for >>>>>>>>> Excel users. However I am attaching a few links as pointers that >>>>>>>>> might help >>>>>>>>> you to easily resolve your query. >>>>>>>>> >>>>>>>>> http://support.microsoft.com/kb/308459 >>>>>>>>> http://office.microsoft.com/en-us/access/HA010345961033.aspx >>>>>>>>> http://www.dbtoolsplus.com/ >>>>>>>>> >>>>>>>>> The last link profides some freeware tools to generate reports >>>>>>>>> directly from Access to HTML. >>>>>>>>> >>>>>>>>> Regards, >>>>>>>>> Andy >>>>>>>>> >>>>>>>>> >>>>>>>>> On Sun, Feb 7, 2010 at 11:25 AM, chandrabhan singh < >>>>>>>>> cs4...@gmail.com> wrote: >>>>>>>>> >>>>>>>>>> Hi Group, >>>>>>>>>> >>>>>>>>>> Please Help me.i have to created a data base name Attendance >>>>>>>>>> Tracker.In which i have to Mention >>>>>>>>>> Emp. code of Team Leaders,Name,Service Level,Count of Roster ed >>>>>>>>>> Agent's.After getting save these >>>>>>>>>> field.what i want next day when i filled count of Present Agent >>>>>>>>>> Status.Program will automatically calculate >>>>>>>>>> Absent ism & Shrinkage(%) of Each Team Leaders Apart from which i >>>>>>>>>> want to show report in >>>>>>>>>> HTML or Front page but i don't know how to write a connection >>>>>>>>>> code.Please find attached file along with >>>>>>>>>> mail attendance tracker.Please Cross Check these code.Plz help me. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Thanks&Regards >>>>>>>>>> c...@ndr@b...@n Singh >>>>>>>>>> 9911255330 >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> >>>>>>>>>> ---------------------------------------------------------------------------------- >>>>>>>>>> Some important links for excel users: >>>>>>>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>>>>>>> http://twitter.com/exceldailytip >>>>>>>>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads >>>>>>>>>> at http://www.excelitems.com >>>>>>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>>>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>>>>>>> 5. 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 >>>>>>>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>>>>>>> HELP US GROW !! >>>>>>>>>> >>>>>>>>>> We reach over 6,700 subscribers worldwide and receive many nice >>>>>>>>>> notes about the learning and support from the group.Let friends and >>>>>>>>>> co-workers know they can subscribe to group at >>>>>>>>>> http://groups.google.com/group/excel-macros/subscribe >>>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> >>>>>>>>> ---------------------------------------------------------------------------------- >>>>>>>>> Some important links for excel users: >>>>>>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>>>>>> http://twitter.com/exceldailytip >>>>>>>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads >>>>>>>>> at http://www.excelitems.com >>>>>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>>>>>> 5. 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 >>>>>>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>>>>>> HELP US GROW !! >>>>>>>>> >>>>>>>>> We reach over 6,700 subscribers worldwide and receive many nice >>>>>>>>> notes about the learning and support from the group.Let friends and >>>>>>>>> co-workers know they can subscribe to group at >>>>>>>>> http://groups.google.com/group/excel-macros/subscribe >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> With Regards >>>>>>>> chandrabhan Singh >>>>>>>> +919711535271 >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> >>>>>>>> ---------------------------------------------------------------------------------- >>>>>>>> Some important links for excel users: >>>>>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>>>>> http://twitter.com/exceldailytip >>>>>>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads >>>>>>>> at http://www.excelitems.com >>>>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>>>>> 5. 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 >>>>>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>>>>> HELP US GROW !! >>>>>>>> >>>>>>>> We reach over 6,700 subscribers worldwide and receive many nice >>>>>>>> notes about the learning and support from the group.Let friends and >>>>>>>> co-workers know they can subscribe to group at >>>>>>>> http://groups.google.com/group/excel-macros/subscribe >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>>> >>> >>> >> >> > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe