Hi All,

I have a workbook containing the accounting for my scout group.

It contains a AnnualReport sheet and a report sheet for each month.

I want the AnnualReport to update automaticly based on each months
report.

I created a button, so that when I finished a monts report (and
verified everything ok) it updates the AnnualReport.

What I'm trying to do in a vba code (assigned to the button) is the
following:
1) look for value in cell B5 of month report (where code is located) -
That contains the expense categorie
2) Look for that value in cells A1 to A50 of sheet AnnualReport
3) Update the value of the cell to the right (offset (1.0)) adding the
value of D5 of months report
4) repeat the operation with the next 10 rows (ie B6 to B15)

I'm kinda lost, everithing I tryied gets me errors.

Thanks in advance.