Closed Thread
Results 1 to 3 of 3

VBA Task allocation macro

  1. #1
    Registered User
    Join Date
    08-29-2019
    Location
    United States Minor Outlying
    MS-Off Ver
    2016
    Posts
    4

    VBA Task allocation macro

    Hey,

    I've been trying to make a macro to automatically allocate tasks to employees taking a condition into account which is that a task cannot be allocated if it is within 20 minutes of the previous task of the employee. The list of tasks also needs to be able to have more tasks added or removed without having to change the code.
    Example:
    20 tasks for 5 employees
    Task 1 to Employee 1, task 2 to Employee 2 etc until task 5 then task 6 gets placed with employee 1 as long as its not within 20 minutes of task 1.
    I've attached a workbook with what I've come up with so far but I haven't had any success in running it yet. If anyone could take a look at it and let me know where I went wrong that'd be fantastic.

    Thanks,
    Mebig
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: VBA Task allocation macro

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-29-2019
    Location
    United States Minor Outlying
    MS-Off Ver
    2016
    Posts
    4

    Re: VBA Task allocation macro

    Holy **** that's incredible. Thank you so much!

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro for allocation
    By somusas in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 10-11-2018, 10:03 PM
  2. Sum-up weekly allocation to Monthly Allocation
    By juan.doe in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-11-2017, 04:41 AM
  3. Replies: 13
    Last Post: 08-04-2015, 09:00 AM
  4. Macro for Average Allocation.
    By sairam2014 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2014, 10:05 AM
  5. task allocation according to manpower and skill set
    By lsl_anna in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-21-2014, 08:47 AM
  6. Macro for Task Allocation to Employees
    By ravikiran in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2013, 04:50 AM
  7. Key Notes related help required
    By pavittersingh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-28-2012, 04:48 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