+ Reply to Thread
Page 2 of 12 FirstFirst 1 2 3 4 ... LastLast
Results 16 to 30 of 173

Macro for equal distribution !

  1. #16
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    195

    Re: Need a macro for allocation of work in team !!!

    Wat is the values that get returns in column M and N

  2. #17
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    195

    Re: Need a macro for allocation of work in team !!!

    Also I see the card cases are getting copy to the card spreadsheet. I want the case I'd which have card should get moved from data to card and it should get deleted in the data spreadsheet.

  3. #18
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Need a macro for allocation of work in team !!!

    OK let me work on the changes. I use columns M and N as a temporary list of the personnel available and the jobs assigned to them in order to facilitate the search for the next person to assign,

  4. #19
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    195

    Re: Need a macro for allocation of work in team !!!

    Hi one more doubt if I don't want to generate separate sheet for users can u let me know which code I would need to delete

  5. #20
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Need a macro for allocation of work in team !!!

    I based the user tabs on your request that each user learned his or her tasks. If you want I can set it up so you pick the user from a list and the task pertaining that user will be listed.

  6. #21
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    195

    Re: Need a macro for allocation of work in team !!!

    Can u do that? And send me the updated macro.

    If possible can we generate Excel sheets and save it in a specific folder. Like batch 1 batch 2

  7. #22
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    195

    Re: Need a macro for allocation of work in team !!!

    Also just copy paste the codes that identify employee presence here. I would like to know which coding represents that

  8. #23
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    195

    Re: Macro for equal distribution !

    Hi there need your suggestion now.

    Each time when I click split card type the entire dump which is already assigned gets split up.

    It is very difficult for me to again copy paste the splitter data to the consolidated data for Allocation.

    Mainly I need duplicate cases not t be assigned second or third time it comes.

    Can u help me? How can we consolidate all the data which is assigned ..

    Please give me some suggestions.

  9. #24
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Macro for equal distribution !

    This is how I will do it. I would keep a master copy in data, have a tab for cards, and another for the rest, a userform-like for reporting each person's assignments and the summary where you can see it summarized. (hidden I would keep a tab for temporary data)

  10. #25
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    195

    Re: Macro for equal distribution !

    Well to organize like this way. Then how do consolidate all assigned data including card in one sheet

  11. #26
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    195

    Re: Macro for equal distribution !

    Duplicates is my big pain. How can I return the same person name who was assigned first for that day.

  12. #27
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Macro for equal distribution !

    Just to be clear. An assignment is given to a person, then this assignment is again entered into the data tab, you want to retain the original person or just flag it as already assigned and assigned to the original person..

  13. #28
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    195

    Re: Macro for equal distribution !

    I want it to retain that same case to that same person. Also can we return value as batch 1 batch 2 when I put Allocation

  14. #29
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    195

    Re: Macro for equal distribution !

    Hi there? Are u working on this modification?

  15. #30
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    195

    Re: Macro for equal distribution !

    Hi there? Any update?

+ Reply to Thread
Page 2 of 12 FirstFirst 1 2 3 4 ... LastLast

Thread Information

Users Browsing this Thread

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

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