Sanoj
Member
Hi All,
Could someone please help me out with the work allocation file I am really in need of one.
I have attached my format in which its required.
1. Allocate each team member by First in First out method by considering Ageing (Sheet1 Col AY)
2. Allocation should be done according the value entered in sheet2 col C & E.
3. The main represents the main responsibility of each team member and support represents secondary responsibility.
4. Sheet2 Col B & D represents sheet1 column B (Region)
Example: If I put the value.
Ammy CZ - 50 and AT - 10
Andy AT-25 and CZ - 10
Then allocation criteria should be:
Then macro should allocate CZ to Ammy first as main for CZ is Ammy considering ageing (=Sheet1!AY:AY) and then to andy in CZ.
Please let me know if anyone still needs clarity.
Thank you in advance...
Regards,
Sanoj.
Could someone please help me out with the work allocation file I am really in need of one.
I have attached my format in which its required.
1. Allocate each team member by First in First out method by considering Ageing (Sheet1 Col AY)
2. Allocation should be done according the value entered in sheet2 col C & E.
3. The main represents the main responsibility of each team member and support represents secondary responsibility.
4. Sheet2 Col B & D represents sheet1 column B (Region)
Example: If I put the value.
Ammy CZ - 50 and AT - 10
Andy AT-25 and CZ - 10
Then allocation criteria should be:
Then macro should allocate CZ to Ammy first as main for CZ is Ammy considering ageing (=Sheet1!AY:AY) and then to andy in CZ.
Please let me know if anyone still needs clarity.
Thank you in advance...
Regards,
Sanoj.