How to find multiple identical cells & add values contained in their rows

[emmi]

I'm trying to find a way to record spend against a cost centres. I have a workbook with several worksheets. One has a list of all transactions against all cost centres. On another I have a list of all cost centres & I need to show the actual expenditure against the forecast expenditure by tracking the actual spend on the first worksheet.

I need to make the process of doing this as simple as possible for the user, so I am thinking that linking a macro to a button is the best thing for the user. I need that macro therefore to find cells containing the same cost centre in one worksheet, add up the spend values in those rows, and set those values against the cost centre forecast in the second worksheet.

Hope this makes sense...

Can anyone help me? I am quite new to all this stuff & would be very grateful!

Thanks in advance,

emmi

 

[AlphaFrog]

Have you considered using a SUMIF function in a formula?

On Sheet2, this formula will match all the cells on Sheet1:Column A that equal Sheet2:A1 and add the corresponding values from Sheet1:ColumnB

=SUMIF(Sheet1!A:A, A1, Sheet1!B:B)