Summing from multiple worksheets

C

Chris

I have a workbook with a large number of worksheets, all
of which are in the same format. The sheets are named by
employee. I would like to sum various cells across the
workbook onto one sheet, eg sum all L48 cells across the
workbook.

Is there a quick way to do this either by formula of
macro? I don't really want to have to create one long
formula by manually clicking through and selecting L48 on
each sheet.

Thanks for any help.
 
R

Ron de Bruin

Hi Chris

Add two dummy sheets(empty sheets)with the name start as the first sheet
and one with the name end as the last sheet of your workbook.
this are empty sheets!!!

All worksheets between these sheets will be sum
with this formula

=SUM(start:end!B2)
 
Top