My boss has set me a challenge of creating a calculation that will distribute work across a section in equal amounts.

Trouble is that we work within alpha splits (I look after cases DUN - GAU).

I dont think its possible but he thinks it is that if the amount of work on my split became to much, and someone else's became lower, the workbook could re-split the work so that we have the same amount of cases again.

Anyone advise if this is possible and what sort of formula would I look at?