+ Reply to Thread
Results 1 to 2 of 2

Assign seats based on schedule

  1. #1
    Forum Contributor
    Join Date
    10-28-2010
    Location
    quebec, canada
    MS-Off Ver
    o365
    Posts
    187

    Assign seats based on schedule

    Good day,

    This could probably done trough a VBA action, the only problem, is that i have absolutely no idea how i can do this....

    Details;

    I'm in a call center, with 44 seats, i want to be able to assign seats, in a specific order (order is already set in cell 1 to 44, from first to assign to last.)

    I need to assign those seats based on a specified schedule in 24h format, so when an agent come in, assign first seat AVAILABLE in the list in order, and so on.... And when an agent leaves, this seat becomes available for another agent, to be choosen in order, in the list.

    Anyone following me on that?

    Is it possible? if yes, i will provide as much info as possible to make this work, but my limited VBA skills cannot compute this one

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Assign seats based on schedule

    Submit your workbook
    If you are happy with my response please click the * in the lower left of my post.

+ 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] populate class seats from list of people
    By lucasairhart in forum Excel General
    Replies: 5
    Last Post: 11-30-2015, 02:14 PM
  2. Replies: 3
    Last Post: 04-23-2013, 03:46 PM
  3. Updating a Schedule based on a master schedule
    By Lukerich in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-21-2013, 12:18 PM
  4. [SOLVED] Allot Seats to Students based on Choice & Percentage
    By v999 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-30-2012, 08:12 AM
  5. Find, compare and assign a value for Schedule Format.
    By Rbeltran in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-11-2009, 11:08 PM
  6. Macro - schedule people for training based off their schedule and available training
    By downed_pipper1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2009, 04:59 PM
  7. [SOLVED] Create patient schedule based on master therapist schedule
    By PapaBear in forum Excel General
    Replies: 8
    Last Post: 10-12-2005, 12:05 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