Hello
The workgroup mode is the Excel built-in option to enter similar formulas or
data into multiple sheets on one workbook.
To do so,
-Right-click on any worksheet tab and select "Select all sheets"
-Enter your formulas into the active sheet.
-When finished, right-click on any worksheet tab and Select "Dissociate
sheets"
(please note menu caption may wary as I am using a french version of Excel)

Now you may navigate through your worksheets and you will notice formulas
are entered into all of them.

HTH
Cordially
Pascal

"englishrose4719" a écrit dans
le message de news: ...
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