Macro for auto work allocation depending on old pending work?

Hi,

I am stuck at a point and i quite cant figure out what to do PLEASE HELP ME, So this is what i am trying to do

I have 20+ agents working I have a master sheet with all the data new work and the old work, I am currently able to separate the old work with the agent name into different multiple sheets and i use a macro for doing that but I have to manually calculate and assign new work depending on the OLD.

For eg John has 20 previous days work pending his target is 80 i assign 60 and for Tim 60 Prev days i assign 20. If anyone can help me or show me a way to assign new work depending on their old work would be great.

The final result i am looking for is there are diff sheets with names of agents along with previous days work I want the new work to go to their respective sheet according to their work pending can this be done.

This is the current macro i run to split data of the old work to different but the new work comes along to a sperate sheet and i manually have to assign new work

Please help me on this

Please Login or Register  to view this content.

the above is what i use now