been thinking about how to do this, maybe it requires a macro?
Resource A is allocated to Task 1 @ 50%, and Task 2 @ 50% for the same week. I now want to change the Task A allocation to 80%, which updates Work to 32hours, and want Task 2 to auto-update to 20% (and the respective Work to 8). Is this doable? Using leveling doesn't reallocate percentage but instead lengthens tasks.
Also appreciate that a particular difficulty is if Resource A is allocated to more than 2 tasks e.g. Task 1 @ 30%, Task 2 @ 30% and Task 3 @ 40%: if I update one, how does it take percent allocation from the other two?