Hello

I have a repetitive task I'd like to automate but feel Macros isn't the one for me, could you shed any light?

I have a list of temp staff names (sorted alphabetically) in column B,
and a list of payments in column F.

The payments are per month, so the surnames appear multiple times depending on how many months they worked (ranging from 1 to 8 months) (eg, Ralph D worked 2 months, his name appears twice for each monthly payment, Lorraine worked 4 months so she has four entries and so on).

In Column G I want to record the total payment per worker to date.
This can't be done easily as the number of rows per worker is inconsitent.

What do I need to use to do this?

Any help much appreciated!