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 D
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