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.

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)



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Chris" wrote in message ...
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.

Perfect! Thanks very much.


-----Original Message-----
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)



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Chris" wrote in
message ...
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.


.