Help Required - Allocation based on exclusion of values

Hi !

Classic typo : replace 1 by L …

With this line

Please Login or Register  to view this content.

You are trying to add 1 to a text value, which you cannot do. try removing the part in red

Hi Marc,

Thank you. Even though if replaced still the task codes are not excluded while assigning.

Can u check and tell me.

Thanks a lot for the quick assistance

Originally Posted by Fluff13

With this line

Please Login or Register  to view this content.

You are trying to add 1 to a text value, which you cannot do. try removing the part in red

I removed that as well however still the values that I enter in task code is not excluding...

Can you please explain what you are trying to do & what is not working?

Hi Fluff,

The macro is designed in such a way that it Excludes the values given in task code and product code sheets And assigns the remaining data to the users in the assigned summary.

So ideally it should look first on column E and check in task code sheet, if the same value is there it should return excluded Task code in column J.

Hope u understood now

Hope u understood now

Fraid not.
Please remember that we have no knowledge of what you are trying to do, or what your data represents.

Originally Posted by Fluff13

Fraid not.
Please remember that we have no knowledge of what you are trying to do, or what your data represents.

Hi Fluff,

This macro assigns data after excluding the values that is given in task code and product code.

However currently it is excluding only the values that was given in product code.

However it does not exclude the values that was given in task code, please let me know if there is any changes that to be done in my code to get this worked.

Until you can supply me with a full, clear & concise description of what you are trying to do, I cannot help

Fluff,

This is a assignment macro. I have modified in such a way that.

1. It Excludes the values that is provided in the task code sheet.(based on column E)
2. Then it Excludes the values that is provided in the product code sheet. (Based on column F)

So after this exclusion, the reamining data which is in the data tab gets assigned to the users.

Let me Know if u still have any questions.

All you are doing is repeating what you have already said, which I don't understand.

Imagine you were standing in a queue at a ticket office & were trying to explain to the person next to you, what you were trying to do.
That is the sort of description that I need.

Hi Fluff

Sorry the objective of the macro is to assign data to the users.

This is macro which equally assigns data to the users.

Can you please let me what u did not understood so I can provide explanation on that.

While assigning I have 2 check points to be checked.

1. Task code (column D). The macro looks for the data that is provided in the task code tab and excludes whatever the values that was there in the first colu.

2. Once task code exclusion is over then, it looks for values in product code and compare with the values in the product code sheet. If it contains same values, it excludes those row in the data and returns a value in column J as "Excluded product code"

The reamining data only after these 2 exclusion should be assigned to the users in the team.

I want to know is there any modifications that need to be done so that exclusion of task code works.

Hi, thanks for the reminder. I will.modify that.

Originally Posted by Pepe Le Mokko

Thread title much more descriptive. Thanks

Thank you. Any help is much more appreciated !!

In this case, whoever is in the next list in the assigned summary will be picked up so it gets evenly distributed.

Say for example, if the last case allocated to "Alan' then when I again put the data it gets allocated to "Harita"

My coding works like that however only the exclusion in task code doesn't work. Not sure if any format has to be changed.

Originally Posted by bakerman2

Try this one.

Hi bakerman,

Thanks for the effort but I still don't see any changes that happened. The macro does not exclude the task code and it simply assigns everything.

Product code is getting excluded however task code is not excluding.Can u please check

Originally Posted by bakerman2

Your sheet variables don't work.

Hi bakerman,

This really works out. Thanks a lot.

Have u changed the entire code? Also I have a small doubt if I do a vlookup with the task code number as that is only available in my raw data. Will the same macro work? Or should I always have the values in text format..


I have attached the file. Please review and let me know ur feedback.

Hi bakerman,

Please refer to my attached file now.I will have only task code number, each task code number has a unique name. So whatever the file u gave me has the direct task code values in it.

If I do a vlookup with task code number and return the task code values, does the macro works??

I want to know if the macro still works with a vlookup function. You refer to my attached sheet where I have returned the task code names for the corresponding task code number.

Originally Posted by bakerman2

Is this what you have in mind ?

Hi I believe you have replaced it by task code number. What I exactly require is to compare the names provided in the task code sheet.

My question is that each task code name carries a number.

If I do a vlookup with task code number (column E) and return the values in column F.

Would that same macro works. Now what I need is compare the vales of F in it the task code sheet and assign accordingly.

Would that be possible?

Hi bakerman,
I am sorry I could not understand. Shift by 1 means u want me to move all the columns???

Originally Posted by bakerman2

The updated code is in my previous post.

I copied to my file, however when I try to add new value, in the task code exclusion list, the code didn't work. Can u check that for me please.

Appreciate all the efforts taken to get my queries solved.

I just copy pasted the code that u have given in your earlier post.

I have not modified anything else. Can u share ur Excel which works fine so I can check again.

Hi Bakerman,

I agree to your point and I made the segment column as empty and the macro works.

Now if I add new data to the sheet, and click assign, the loop works indefinitely, the macro assigns repeatedly on how much I click the assign button.

Can u check and let me know if I add any code to break the loop.

Hi bakerman,

The macro works fine now. Really thank you for all the efforts taken to get it sorted.

Duplicates alone is not working, it does not return the same name which was assigned earlier before, I will try to fix it, if there is any code to altered, please let me know.

Thanks a ton for the support !!!!