Employee cost allocation across cost centers based on percentage

Hello,

I'm looking for a way through a VBA macro to allocate employee cost by cost centers based on percentage allocation.

I've attached an example file with the input (extract for instance from our ERP), the allocation table (where the allocation of the employee by cost center is visible) and the desired output. I'm looking for a VBA code as the input list and the general ledger accounts are variable.

Many thanks in advance

Regards