+ Reply to Thread
Results 1 to 1 of 1

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'm looking for guidance or suggestions on how to create a vacation roster that emails each person and their manager when it is their turn to pick -- basically a form that has all the weeks listed, allows users to pick their weeks, then emails the next person when they are done. so maybe a that allows them click they are complete and sends the email to the next person in the list.

    The guideline for the selections would be user have 3 rounds to pick

    First Round - they can pick 1 or 2 consecutive weeks
    Second Round - they can pick 2 weeks consecutive or if 3 weeks are chosen then 2 weeks consecutive and the 3rd split. if only 2 weeks are chosen they can not be split.
    Third Round 2 consecutive or split weeks.

    Maybe what I have attached is a start, but I'm not sure that is even a good way to approach it.

    The final document will be on a sharepoint page or shared drive for everyone to access if that changes anything in the process.
    Attached Files Attached Files

+ 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. [SOLVED] How to leave leave cell blank if all cells added together = 0
    By jmitch26 in forum Excel General
    Replies: 3
    Last Post: 07-30-2019, 11:00 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

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