Are you saying you want me to design something like what you already have?? If so.. I'd need your requirements.. and the time to do it. Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -----------------------------------------
________________________________ From: Yahya Muhammad <yahya...@gmail.com> To: excel-macros@googlegroups.com Sent: Thu, October 25, 2012 4:00:10 AM Subject: Re: $$Excel-Macros$$ Highlight annual leave schedule of each staff for easy comparison Dear Paul Thanks for the support. Yours is an excellent attendance tracker, which is much more than what I needed. Can I have a simple, single sheet vacation planner, similar to the one I have attached ? On Wed, Oct 24, 2012 at 9:19 PM, Paul Schreiner <schreiner_p...@att.net> wrote: YahYa, > >Here is a scrubbed version of an application I wrote several years ago. > >In this case, individual Attendance is recorded on separate sheets >I used User Names: > Micky Dolenz > Michael Nesmith > Peter Tork > Davy Jones > >For each user, the sheet shows their "Allowed" Vacation days. >We are allowed to schedule our "vacation" in 1 hour increments. >When recording future vacation the number of hours is followed by a "V". >Therefore, if I'm scheduled for a full day vacation on Friday, >I place "8V" in the cell for that date. >Once that time has actually been "taken", value is changed to 8. > >If, for some reason, something comes up and an employee must take a vacation >day that is not scheduled, the hours (usually 8) is placed in the date >actually taken. >A warning message will be displayed indicating that more vacation is scheduled >than allowed. The user must then remove one of the other scheduled days. > >In this application, absenses due to "illness" is also tracked by using >8I to indicate a "sick day". > >On the Summary sheet, the button is used to read from the other sheets >and indicate the number of employees scheduled, (or have already taken) vacation >time on a given day. > >A Comment is created, referring to the users that are scheduled for these days. > >Let me know if this is helpful. > >Paul >----------------------------------------- >“Do all the good you can, >By all the means you can, >In all the ways you can, >In all the places you can, >At all the times you can, >To all the people you can, >As long as ever you can.” - John Wesley >----------------------------------------- > > > > > ________________________________ From: Paul Schreiner <schreiner_p...@att.net> >To: excel-macros@googlegroups.com >Sent: Wed, October 24, 2012 7:49:35 AM >Subject: Re: $$Excel-Macros$$ Highlight annual leave schedule of each staff >for >easy comparison > > > >That's a start... but it doesn't have all of the days of the year. >(you probably noticed that) > >Several years ago (10+?) I put together an attendance tracker for my supervisor. >There were separate sheets for each individual in the department, >then a summary sheet that displayed how many people were scheduled to be absent >on any given day. >It also kept track of days missed due to illness, or other. >In addition, each employee in the department was eligible for a different number >of days of vacation per year, depending on their years of service. >This kept track of vacation days scheduled as well as days actually taken. >We also allow 1/2 day vacation, which it also kept track of. > >I'll try to get an updated copy, scrub it to remove personal info, and post it. > >Paul >----------------------------------------- >“Do all the good you can, >By all the means you can, >In all the ways you can, >In all the places you can, >At all the times you can, >To all the people you can, >As long as ever you can.” - John Wesley >----------------------------------------- > > > > > ________________________________ From: Yahya Muhammad <yahya...@gmail.com> >To: excel-macros@googlegroups.com >Sent: Wed, October 24, 2012 3:19:47 AM >Subject: $$Excel-Macros$$ Highlight annual leave schedule of each staff for >easy >comparison > > >Hi experts > > >I want to compile the annual leave schedule of each staff in the department in >excel. The idea is to have all the schedule in one work sheet, for easy >comparison and to know the leave overlapping,if any, at one glance. Currently >I >am using the attached sheet, which I think, can be modified/automated to have >a >better form. Awaiting your help please.-- > >Join official facebook page of this forum @ >https://www.facebook.com/discussexcel > >FORUM RULES (1120+ 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. > > >6) Jobs posting is not allowed. > >7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > >NOTE : Don't ever post personal or confidential data in a workbook. Forum >owners >and members are not responsible for any loss. >--- >You received this message because you are subscribed to the Google Groups "MS >EXCEL AND VBA MACROS" group. >To post to this group, send email to excel-macros@googlegroups.com. >To unsubscribe from this group, send email to >excel-macros+unsubscr...@googlegroups.com. > > >-- >Join official facebook page of this forum @ >https://www.facebook.com/discussexcel > >FORUM RULES (1120+ 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. > > >6) Jobs posting is not allowed. > >7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > >NOTE : Don't ever post personal or confidential data in a workbook. Forum >owners >and members are not responsible for any loss. >--- >You received this message because you are subscribed to the Google Groups "MS >EXCEL AND VBA MACROS" group. >To post to this group, send email to excel-macros@googlegroups.com. >To unsubscribe from this group, send email to >excel-macros+unsubscr...@googlegroups.com. > > > >-- >Join official facebook page of this forum @ >https://www.facebook.com/discussexcel > >FORUM RULES (1120+ 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. > > >6) Jobs posting is not allowed. > >7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > >NOTE : Don't ever post personal or confidential data in a workbook. Forum >owners >and members are not responsible for any loss. >--- >You received this message because you are subscribed to the Google Groups "MS >EXCEL AND VBA MACROS" group. >To post to this group, send email to excel-macros@googlegroups.com. >To unsubscribe from this group, send email to >excel-macros+unsubscr...@googlegroups.com. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
