Summarise few columns when the name match - various rows and jobs

Hi all

I am new to VBA, I have tried some of the metholds but it's seems not work for me.

I have a list of individuals(100+), each individuals have various shifts(100+).
I want to summarise the shift data for each individual in a cell below the last row.
When the shift name match, I want to add up the quantity of hours and the total cost of the matched shifts.

In example file:
Column A-G are the Sample data, Column J-P are the result I am looking for.

Thank you so much ^^

Please let me know if you need more information, cheers

Thank you so much nankw83 , it works very well.

I should have a long way to learn on VBA

Glad to help & thanks for the reps

Hi nankw83

I would like to change the column from 1, 3, 5, 7 to 21, 27, 29, 30
Which part of the code do I need to change? I tried to change the column number in the first FOR loop but it does not work.

Can I please ask if you can put in some simple explanations in the code? thanks

Originally Posted by nankw83

Hi bb1228,

Try below code ... I have tried to put as much comments as I could, hope that helps

Please Login or Register  to view this content.

Thank you so much nankw83 for your comment and updating the codes it's work well, I am really appreaciate

I am sorry to keep changing, just want to see if you can help me to add one more thing to the last row of each [individual code]
Could you please add the total of the total column(Column AC) for each individual into the same cell of the calculate data.... sorry for the inconvenience it caused, thanks.

Hi nankw83

Thanks for your quick response I am appreciated.
However, when I tried to apply it to my actual excel with some of my codes,
it is not work properly.

It's my bad,I didn't mention it in details.

When I apply you summary calcuation in to the excel file,
I will need to run some of my codes to adding one big Header few lines for each individual
and a small header above each different Employee Code, please see the screenshot below.

Below is the screenshot after run your codes and my codes, except the red numbers.
After run code.PNG

Since the column AC is broken up, I think it may affect your calculation of "Total" codes

I am so sorry to being a pain. Do you think it's possible to add up the total and put it
after the word "Summary: "?

Thanks