how to copy formulas across a 1-31 day file and month end total

[Guest]

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

 

[Roger Govier]

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 1ay 2'!B2)
Note the single quotes, which are necessary if there are any spaces in
the sheet names

 

[papou]

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

 

[Guest]

Hi "Rose"

If the data format is the same on each sheet and you just want the total of
a cell in all sheets add a new sheet at the beginning of the book and another
at the end. Call them Start and End. Then on your Sumary sheet use the formula

=SUM(Start!A1:End!A1) and copy down and across.

If the data is different on each sheet have a look at >Data>Consolidation.
You can add the range in each sheet and produce a summary of all sheets. Be
careful to link the data so that it can be updated next month.

If the ranges are likely to change in future months you might like to add
blank rows and columns to the range when setting up your model.

Regards
Peter

 

[Guest]

Thanks Roger but i think ive confused the issue and just wanted to check
before i mess up big time!

my summary sheet is in columns of day 1, day 2, day 3 etc, and corresponds
with the worksheets day 1, day 2, day 3 etc. The columns are just totals of
certain bits of information from the daily sheets.

eg on the daily sheets would be list of visitors names to the showroom,
models they looked at, demos done, quotes etc showing as a breakdown per
visitor.

The summary page is just of total of visitors, models, demos etc.

Will you solution still be ok?

thanks lots
Carol

 

[Roger Govier]

Hi Carol

I think from what you are now describing, my suggestion will be totally
wrong for what you are trying to achieve.

I have to go out right now for a while, but if you want to send me a
copy of what you have so far, I will take a look and get back to you. I
think there will be a more efficient way to organise your data, to
enable easy summaries.

If you want to mail the file to me direct, remove NOSPAM from my email
address and do the obvious with the AT
roger AT technology4uNOSPAM.co.uk