+ Reply to Thread
Results 1 to 3 of 3

Assign workload to specific users

  1. #1
    Registered User
    Join Date
    02-25-2014
    Location
    Poland
    MS-Off Ver
    Excel 2013
    Posts
    18

    Assign workload to specific users

    hello everybody
    sorry if this is a newbie question, but my skills in VBA are very limited.

    I have an excel file with the following columns:

    Ticket Nr To be archived Owner Final status Sub Process Note
    8001883340 yes GRAVIDANZA POST PARTUM E ART. 7 0
    8001883370 yes GRAVIDANZA POST PARTUM E ART. 7 0
    8001883381 yes GRAVIDANZA POST PARTUM E ART. 7 0
    8001883489 yes GRAVIDANZA POST PARTUM E ART. 7 0
    8001883478 yes GRAVIDANZA POST PARTUM E ART. 7 0
    8001883528 yes GRAVIDANZA POST PARTUM E ART. 7 0
    8001883517 yes GRAVIDANZA POST PARTUM E ART. 7 0
    8001883555 yes GRAVIDANZA POST PARTUM E ART. 7 doc parziale

    There about 500 lines and I need to assign equally the workload among the colleagues.
    Right now I am filling manually column "owner" with the names of the people involved in the project.
    First I count how many lines I have... I divide them into the colleagues (let's say 18...) and write their name in column owner one by one. Remaining cells which were left out by the division, are filled randomly using above colleague's name.

    I would like to have this process automated somehow. Excel should already know the names of people involved and divide the workload equally and leaving out the very last lines which were not assigned.

    Is it possible?

    Thanks in advance for your fantastic job

  2. #2
    Registered User
    Join Date
    02-25-2014
    Location
    Poland
    MS-Off Ver
    Excel 2013
    Posts
    18

    Re: Assign workload to specific users

    I add a test file for your information
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-25-2014
    Location
    Poland
    MS-Off Ver
    Excel 2013
    Posts
    18

    Re: Assign workload to specific users

    Anybody has an idea? Thank you very much

+ 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] VBA - Run only for specific users
    By honger in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-04-2014, 05:34 PM
  2. Replies: 1
    Last Post: 02-04-2012, 06:26 PM
  3. Replies: 2
    Last Post: 12-15-2011, 12:13 PM
  4. Replies: 3
    Last Post: 03-28-2011, 10:53 AM
  5. [SOLVED] don't allow users to assign the cntrl+s as a short cut for macro
    By Sreenath in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-05-2005, 02:15 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