Hi

For your summary, you can use
=SUM(1:31!B2)
to add all of the values from cell B2 on sheet 1 through sheet 31.
This assumes that the sheets are named 1, 2, 3 etc.
If they are called Day 1, Day 2 etc then it would be
=SUM('Day 1:Day 2'!B2)
Note the single quotes, which are necessary if there are any spaces in
the sheet names
--
Regards

Roger Govier


"englishrose4719" wrote in
message ...
Ive got 31 x daily figures spreadsheets which i need to total up
(daily) on a
Month End sheet. Is there a quick way to copy the formulas across
instead of
having to rewrite it on all 31 worksheets? Ive not had much
experience with
Excel but have got the formulas transferring from the Day 1 sheet to
the
Month End sheet ok. Help in a non technical manner would be great
please?!
thanks