Dear Lalit, Your really great scripter. Amazing skills !!!!!!!!
Thanks for all my requirement which is through in less time . On Sat, Apr 28, 2012 at 11:59 PM, ╰» ℓαℓιт мσαнη <mohan.pande...@gmail.com>wrote: > Dear yogananda > > Please find attached and try this one if it is working for you as per your > requirement. > > *Regards,* > *Lalit Mohan* > > > On Sat, Apr 28, 2012 at 10:15 PM, yogananda muthaiah < > yogananda.mutha...@gmail.com> wrote: > >> Hi Lalit >> >> Any luck ? >> >> ---------- Forwarded message ---------- >> From: yogananda muthaiah <yogananda.mutha...@gmail.com> >> Date: Sat, Apr 28, 2012 at 6:58 AM >> Subject: Re: $$Excel-Macros$$ Attendance tracking >> To: excel-macros@googlegroups.com >> >> >> Dear Lalit >> >> Thank you soo much for your valuable effort. You are really great mentor >> to us . >> >> I have made some clear points to understand better which is highlighted >> in blue color fields >> >> * >> * >> >> 1) In Resigned sheet - Employee code no 36258 enters , In tracker >> sheet Row 15 should be Flashing or Blinking warning ( I have already >> made myself a VB code script but need your alternation needs to be done) >> - Refer Module1 >> >> 2 ) In Holiday List Sheet - Once the Holiday date is entered , then >> Hshould reflect as per Location lookup /match in B column both Holiday >> Sheet & Tracker sheet as per the Date (Example is in Holiday list sheet) >> >> 3) Slight change for Total leave "BL" (AK column) -- If continous AL >> reflect in date range for 5days then it should come as BL instead of Total >> count. >> >> >> >> 2012/4/28 ╰» ℓαℓιт мσαнη <mohan.pande...@gmail.com> >> >>> Hi yogananda >>> >>> Please find attached with solution except third point. >>> >>> Either the requirement is not clearly mentioned in third point or i am >>> not able to understand it actually what change you want in VBA. >>> >>> >>> *Regards,* >>> *Lalit Mohan, >>> Senior Associate* >>> >>> >>> >>> On Fri, Apr 27, 2012 at 10:23 PM, yogananda muthaiah < >>> yogananda.mutha...@gmail.com> wrote: >>> >>>> Hi, >>>> >>>> Please help out >>>> >>>> >>>> On Fri, Apr 27, 2012 at 4:31 PM, yogananda < >>>> yogananda.mutha...@gmail.com> wrote: >>>> >>>>> Hi Guys, >>>>> >>>>> Wats up, there is no one to revert on my issue raised. Please resolve >>>>> >>>>> >>>>> >>>>> On Friday, April 27, 2012 1:18:44 PM UTC+5:30, yogananda wrote: >>>>> >>>>>> Hi, >>>>>> >>>>>> Please help out >>>>>> >>>>>> On Friday, April 27, 2012 7:36:30 AM UTC+5:30, yogananda wrote: >>>>>> >>>>>>> Hi Champs >>>>>>> >>>>>>> Did anyone tried out to solve my problem >>>>>>> >>>>>>> ---------- Forwarded message ---------- >>>>>>> From: yogananda muthaiah <yogananda.mutha...@gmail.com> >>>>>>> Date: Thu, Apr 26, 2012 at 11:12 PM >>>>>>> Subject: Fwd: $$Excel-Macros$$ Attendance tracking >>>>>>> To: excel-macros <excel-macros@googlegroups.com**> >>>>>>> >>>>>>> >>>>>>> Dear Friends >>>>>>> >>>>>>> Did anyone put your hands on it ???? >>>>>>> >>>>>>> Regards >>>>>>> Yogananda Muthaiah >>>>>>> >>>>>>> ---------- Forwarded message ---------- >>>>>>> From: yogananda muthaiah <yogananda.mutha...@gmail.com> >>>>>>> Date: Thu, Apr 26, 2012 at 10:07 PM >>>>>>> Subject: Re: $$Excel-Macros$$ Attendance tracking >>>>>>> To: excel-macros@googlegroups.com >>>>>>> >>>>>>> >>>>>>> Dear Experts, >>>>>>> >>>>>>> Thank You *Lalit Mohan* for your valuable effort. >>>>>>> >>>>>>> I am attaching my actual requirement mentioned in workbook where i >>>>>>> would require all your solutions... >>>>>>> >>>>>>> Also your feedback/suggestion is welcomed. >>>>>>> >>>>>>> Regards >>>>>>> Yogananda. Muthaiah >>>>>>> >>>>>>> >>>>>>> 2012/4/25 ╰» ℓαℓιт мσαнη <mohan.pande...@gmail.com> >>>>>>> >>>>>>>> Please find the attached file with solution >>>>>>>> >>>>>>>> >>>>>>>> *Regards,* >>>>>>>> *Lalit Mohan* >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Wed, Apr 25, 2012 at 9:22 PM, yogananda muthaiah < >>>>>>>> yogananda.mutha...@gmail.com> wrote: >>>>>>>> >>>>>>>>> Hi Experts >>>>>>>>> >>>>>>>>> I would require your help in making it simple >>>>>>>>> >>>>>>>>> For Example >>>>>>>>> >>>>>>>>> Employee No 111 has taken a leave from 02/04/2012 to 10/04/2012 - >>>>>>>>> 7days which i would require a auto update on below table for given >>>>>>>>> date range as "SCL" ( as per column "E") >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> Regards >>>>>>>>> Yogananda Muthaiah >>>>>>>>> Ph : 973 123 7267 >>>>>>>>> >>>>>>>>> -- >>>>>>>>> FORUM RULES (986+ members already BANNED for violation) >>>>>>>>> >>>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and >>>>>>>>> Need >>>>>>>>> Advice will not get quick attention or may not be answered. >>>>>>>>> >>>>>>>>> 2) Don't post a question in the thread of another member. >>>>>>>>> >>>>>>>>> 3) Don't post questions regarding breaking or bypassing any >>>>>>>>> security measure. >>>>>>>>> >>>>>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>>>>> >>>>>>>>> 5) Cross-promotion of, or links to, forums competitive to this >>>>>>>>> forum in signatures are prohibited. >>>>>>>>> >>>>>>>>> NOTE : Don't ever post personal or confidential data in a >>>>>>>>> workbook. Forum owners and members are not responsible for any loss. >>>>>>>>> >>>>>>>>> ------------------------------**------------------------------** >>>>>>>>> ------------------------------**------------ >>>>>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> FORUM RULES (986+ members already BANNED for violation) >>>>>>>> >>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>>>>> Advice will not get quick attention or may not be answered. >>>>>>>> >>>>>>>> 2) Don't post a question in the thread of another member. >>>>>>>> >>>>>>>> 3) Don't post questions regarding breaking or bypassing any >>>>>>>> security measure. >>>>>>>> >>>>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>>>> >>>>>>>> 5) Cross-promotion of, or links to, forums competitive to this >>>>>>>> forum in signatures are prohibited. >>>>>>>> >>>>>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>>>>> Forum owners and members are not responsible for any loss. >>>>>>>> >>>>>>>> ------------------------------**------------------------------** >>>>>>>> ------------------------------**------------ >>>>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> >>>>>>> >>>>>>> >>>>>>> Regards >>>>>>> Yogananda Muthaiah >>>>>>> Ph : 973 123 7267 >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> >>>>>>> >>>>>>> >>>>>>> Regards >>>>>>> Yogananda Muthaiah >>>>>>> Ph : 973 123 7267 >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> >>>>>>> >>>>>>> >>>>>>> Regards >>>>>>> Yogananda Muthaiah >>>>>>> Ph : 973 123 7267 >>>>>>> >>>>>>> -- >>>>> FORUM RULES (986+ members already BANNED for violation) >>>>> >>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>> Advice will not get quick attention or may not be answered. >>>>> >>>>> 2) Don't post a question in the thread of another member. >>>>> >>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>> measure. >>>>> >>>>> 4) Acknowledge the responses you receive, good or bad. >>>>> >>>>> 5) Cross-promotion of, or links to, forums competitive to this forum >>>>> in signatures are prohibited. >>>>> >>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>> Forum owners and members are not responsible for any loss. >>>>> >>>>> >>>>> ------------------------------------------------------------------------------------------------------ >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>> >>>> >>>> >>>> -- >>>> >>>> >>>> >>>> Regards >>>> Yogananda Muthaiah >>>> Ph : 973 123 7267 >>>> >>>> -- >>>> FORUM RULES (986+ members already BANNED for violation) >>>> >>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>> will not get quick attention or may not be answered. >>>> >>>> 2) Don't post a question in the thread of another member. >>>> >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> >>>> 4) Acknowledge the responses you receive, good or bad. >>>> >>>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> >>>> >>>> ------------------------------------------------------------------------------------------------------ >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com >>> >> >> >> >> -- >> >> >> >> Regards >> Yogananda Muthaiah >> Ph : 973 123 7267 >> >> >> >> >> -- >> >> >> >> Regards >> Yogananda Muthaiah >> Ph : 973 123 7267 >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- Regards Yogananda Muthaiah Ph : 973 123 7267 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
