+ Reply to Thread
Results 1 to 5 of 5

Help with leave schedule

  1. #1
    Registered User
    Join Date
    12-11-2015
    Location
    louisville ky
    MS-Off Ver
    2010
    Posts
    22

    Help with leave schedule

    I have a pretty basic start on a schedule but I'm stuck on how to limit the number of times a week can be picked, I would like to limit it to 7, Also I'd like a summary on the second tab listing who picked what week.
    Any suggestions?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,425

    Re: Help with leave schedule

    Perhaps this will be a start.
    Helper columns (which may be moved and or hidden for aesthetic purposes) are added to the summary sheet.
    Column P counts the number of times a week has been chosen using: =COUNTIFS(Choices!E$3:M$55,A2)
    Column R lists those weeks that have been chosen less than 7 times using:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    The contents of column R are now assigned to the named range "list1" which is used in data validation.
    I have played with an idea as to how fill the summary sheet and have managed as far as filling in the "selected by" columns using:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    I haven't figured out how to fill the "choice#" columns and will try to come back to that unless someone else has solved first.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,425

    Re: Help with leave schedule

    Here is the completed formula for "Selected by" and "Choice#" on the Summary sheet:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    12-11-2015
    Location
    louisville ky
    MS-Off Ver
    2010
    Posts
    22

    Re: Help with leave schedule

    that works great thank you so much for the help.

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,425

    Re: Help with leave schedule

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with leave schedule
    By terence17 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-23-2019, 05:46 PM
  2. Replies: 6
    Last Post: 02-13-2019, 05:47 AM
  3. Leave Schedule - Excel VBA
    By PrimaSatria in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-05-2018, 02:08 AM
  4. [SOLVED] Leave tracker - how to use formula to automate the total leave days
    By yiyi2 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-16-2018, 10:59 PM
  5. Small Program to calculate and input Personal leave in an employee schedule
    By curiousdesi in forum Excel Programming / VBA / Macros
    Replies: 28
    Last Post: 09-04-2015, 02:15 AM
  6. Replies: 5
    Last Post: 03-03-2015, 01:38 PM
  7. How to create a Leave Schedule in excel 2007
    By datuelijah in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2012, 09:21 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1