Macro to Automatically Assign Remaining Availability

[Scott Mitchell]

Anyone out there have a macro that will automatically assign the
remaining availability for a resource to a task for a given duration?

For example:

Name Start Finish Work Resource
Task 1 1/1/02 1/3/02 2d Bob[67%]
Task 2 1/4/02 1/6/02 1d Bob[33%]
Task 3 1/1/02 1/6/02 ?? Bob[???]

I want a macro that automatically takes Bob's remaining availability
for the period between 1/1/02 and 1/6/02, and puts that as the
timephased work for task 3. If you have one, please share!

Thanks in advance for any help,
Scott