Is it Vlookup or Sum Product ?

[sooty8]

Hi All

I have a weekly sheet within the workbook and every Tuesday I receive it. Column A is always in the same alphabetical order as in the attached file and it covers rows 2 thru 23 ( although only 3 are displayed with data changed for obvious reasons) I have to do a yearly account say we start with Chunal -SC as displayed and it is entered on the 2nd row of the Yearly Sheet on the (2) Weekly sheet Chunal - SC is automatically updated with the new totals added to the one already in place and so on down the rows 2 thru 23 - I need to retain all the sheets within the workbook for year end checking. Would prefer it within a Macro that on click would do the update.

Regards

Sooty 8

[mdmackillop]

If all the data is corresponding, you can use a simple formula to total from the first to last selected sheets

=SUM('Weekly Final (1):Weekly Final (3)'!C2)

[sooty8]

Hi MD

Thanks for the reply - however I cannot get it working will have another try tomorrow - going home now.

Regards

Sooty8

[mdmackillop]

Here's an example

[sooty8]

Hi MD

Thanks for the Example that will do just the job - now learned something new.

Many Thanks

Sooty8