+ Reply to Thread
Results 1 to 2 of 2

On Call Rotation

  1. #1
    Registered User
    Join Date
    02-02-2022
    Location
    Canada
    MS-Off Ver
    2020
    Posts
    19

    On Call Rotation

    Im looking for some help setting up an automated "sheet" for oncall rotation

    needs to go be least seniority to highest and consider vacation bookings

    perhaps i click a button and it runs the "program" to populate the schedule
    needs 1 person per yard (PC / Hazel) and 1 Operator each weekend for the year

    see workbook
    Attached Files Attached Files
    Last edited by robfledderus; 04-10-2024 at 05:12 PM.

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

    Re: On Call Rotation

    Would it be correct to assume that Jim Hutchinson and Jordan Guiney would get the first assignment as they are the most recent hires?
    Are you only looking for VBA solutions or would formula/feature solutions be acceptable?
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Put Call Log in date order, based on a details call log sheet.
    By Biggsy2020 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-06-2022, 07:40 AM
  2. [SOLVED] Call Rotation Help
    By aharb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-25-2013, 01:48 PM
  3. Repeat call count for call center
    By arifmasum in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-08-2013, 10:03 PM
  4. How to set call count according to call date and time
    By naveen4pundir in forum Access Tables & Databases
    Replies: 0
    Last Post: 04-27-2012, 02:13 AM
  5. on call rotation calender
    By SUPERFARMAND in forum Excel General
    Replies: 1
    Last Post: 12-23-2008, 05:28 AM
  6. [SOLVED] Call Center Management: How to calculate 'cost per call'
    By Denniso6 in forum Excel General
    Replies: 2
    Last Post: 06-25-2006, 12:10 PM

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