Work allocation to employees so that they are involve according to the requirement

Hi there,

Iam new to excel programming/Macro.
Iam looking for a solution to assign different tasks to a list of employees so that it should not exceed the percentage required for each function.

For the execution of this i have two worksheets.

One having monthly data in the form of what the person is doing.
For eg


TOM TINA
Friday A A
Saturday
Sunday
Monday B A
Tuesday C C
WednesdayC A
Thursday C A
Friday C B
Saturday
Sunday
Monday A A
Tuesday B C
WednesdayB B
Thursday C A
Friday OFF
Saturday
Sunday
Monday OFF C
Tuesday C A
WednesdayC A
Thursday C B
Friday C A
Saturday
Sunday
Monday B OFF
Tuesday A OFF
WednesdayB OFF
Thursday C OFF
Friday C OFF


And the other workbook contains what percentage is required to work on projects.

eg -
A+B C

TOM 0.5 0.5
TINA 0.8 0.2


So TOM is required to work 50 % on Aand B together and 50 % on C
And Tina 80% on And B together and 20% on C.

so macro should be that when assigning work on the first sheet it should be equally allocated according the values obtained from the second sheet.
Please help

thanks

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
http://www.excelforum.com/excel-prog...quirement.html
Thread Closed.