Help with Splitting Charges to Cost Centres According to %

[OkampoVic]

Hi Guys,

This is my first time in this form and hope to obtain some help with a perplexing Excel issue.

We have a number of staff working on different projects and consequently different cost centres. I am trying to split their payroll charges (for example basic pay, employer's NI contribution) to the respective cost centres. I am working with two spreadsheets:
1) Raw data (containing just the payroll data)
2) Spreadsheet recording the % split per cost centre

I am working with over 500 employee payroll data where at least 300 of them have splits. I have attached the spreadsheets.

Many thanks in advance for your help!

Victory