automating repetitive tasks

[hoshino]

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!

[stanleydgromjr]

hoshino,

See the attached workbook "Automating repetitive tasks - hoshino.xls".

The formula in cell H2 (copied down):
=SUMPRODUCT(($B$2:$B$1000=$G2)*($F$2:$F$1000))

You will not have to sort your data in column B.


If you would like this automated, then please post your workbook (and I will create a macro for you) - scroll down and see "Manage Attachments".


Have a great day,
Stan

[hoshino]

Stanley

Thank you so much for the answer, that is an intellegent way to do it.
I can't upload the real workbook for priivacy reasons but have attached an example close to what I am working with....

If its possible to make a Macro for this I'd be most appreciative,


Thank you!

[rylo]

Hi

If columns C:E aren't really blank in your data, but have headings etc, then try using a pivot table to generate the list of unique names and sum the amounts.

rylo

[ravishankar]

Hi
Here is a macro which sums col F of each worker and lists it in col H & I
ravi