Help with Splitting Charges to Cost Centres According to %

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

Are there only 3 cost centres?

hi John,

There are more than 3 cost centres but the splits are always a maximum of 3. Hope that made sense.

hi dflak,

Many thanks for your response! Brain's fried at the moment but will have a look at your solution. Thanks again for taking the time to reply-much appreciated

Do a lookup on the EE id; Sum the amounts to get Total for Each EE. See attached.

solution with code

Please Login or Register  to view this content.

Kind regards
Leo

Hi Leo, thanks for taking the time to respond. I have no clue about coding but your help is appreciated nonetheless