hello everyone, please help with the query below. Regards Seema On Saturday, 5 May 2012 17:54:42 UTC+5:30, Seema wrote:
> hi, > > thankyou. the tracker looks good. but it allows the user to have the same > day off for two consecutive weeks. and also allows the user to choose > multiple days off in the same week. > > please help in putting these two conditions. > 1. the user should not be allowed to have the same day off for 3 > consecutive weeks, ex: if the user has monday off for this week, the > application shud not allow him to have monday off for week2 and week3. > 2. the user should not be allowed multiple days off in the same week. > > regards > Seema > On Saturday, 5 May 2012 00:10:20 UTC+5:30, Lalit_Mohan wrote: > >> i have made some changes in Noorain's code :) >> >> PFA >> >> *Regards,* >> *Lalit Mohan* >> *https://www.facebook.com/buzinesstransformation*<https://www.facebook.com/buzinesstransformation> >> >> >> >> >> On Fri, May 4, 2012 at 11:16 PM, Seema <vasee...@gmail.com> wrote: >> >>> hi, >>> >>> thank you for the effort. but the sheet is not getting updated instead >>> throws an error asking to debug at line15. >>> also, please let me know the logic applied here. >>> >>> Regards >>> >>> On Friday, 4 May 2012 22:51:29 UTC+5:30, NOORAIN ANSARI wrote: >>> >>>> Dear Vaseema, >>>> >>>> Please see attached workbook, Hope it will help to you. >>>> >>>> -- >>>> Thanks & regards, >>>> Noorain Ansari >>>> www.noorainansari.com >>>> www.excelmacroworld.blogspot.**com<http://www.excelmacroworld.blogspot.com/> >>>> >>>> On Fri, May 4, 2012 at 11:29 AM, Seema <vasee...@gmail.com> wrote: >>>> >>>>> >>>>> hello, >>>>> >>>>> i am using a form as a user interface for an employee to enter the off >>>>> day of their choice week on week. >>>>> >>>>> i want to update the tracker based on the entries from the combobox. >>>>> >>>>> Attached is the sample file with the entry format. >>>>> >>>>> Any help is highly apprecaited. >>>>> >>>>> Regards >>>>> Seema >>>>> >>>>> >>>>> -- >>>>> 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 >>> >> >> -- 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
