+ Reply to Thread
Results 1 to 1 of 1

Setting up a calendar based on employee preferences

  1. #1
    Registered User
    Join Date
    04-01-2021
    Location
    Boston
    MS-Off Ver
    Office 16
    Posts
    1

    Setting up a calendar based on employee preferences

    I use this excel workbook to figure out how to schedule my employees based on their responses to a google form. The FIRST SHEET on excel is the output of the Google Form. The second is the grid that I used to keep track of people who can work when. I spend most of the time copy and pasting back and forth which takes me a while. I want to write VBA code that would allow me to assign constraints like what day and shift the person prefers and then put their name in the 2nd sheet where they could work.

    I would manually check the preferred, not preferred neutral to make sure people don't work with people they don't want to work with. Is this something I can use something like a macro-enabled solver? I am not sure.

+ 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. Split Table Based on Employee Name, Save and Email a workbook for each employee
    By bilbo85 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-03-2020, 07:13 AM
  2. Dividing n children into classes with preferences (up to 4 preferences per child)
    By Little-Miss-Dynamite in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2019, 02:39 AM
  3. [SOLVED] Need a formula for allocations based on preferences and Priorties
    By MANSIJAIN in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-30-2017, 10:39 PM
  4. Need help with Randomly Sorting people based on preferences
    By RoelKing in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-09-2016, 06:00 AM
  5. [SOLVED] Generating Report Based On Name & Month - Employee Calendar
    By Gtrtim112 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2013, 07:05 PM
  6. Replies: 0
    Last Post: 04-25-2011, 04:28 PM
  7. Generating name assignments based on user indicated preferences
    By exceluzer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-16-2011, 04:52 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