Copying formula cells across multiple worksheets??

[Mark McInerney]

Hi,

I am setting up a cash control system for my retail outlet. Each day has it's own worksheet - Sunday thru Saturday.

I am now setting up a weekly control sheet that summarises the week for me.

If for example the Daily Sales are in Cell A1 in each of the 7 worksheets (Sun thru Sat) is there an easy way of copying in the reference to Cell A1 for each of the worksheets without having to do each one individually?

e.g. at the moment I have a range b1:b7 on my summary sheet. The formula in Cell b1 is =Sunday!a1. I am then writing in Cell b2 =Monday!a1 and so on so forth...is there a quicker way of copying and pasting this in?

Any help, advice, greatly appreciated - Many Thanks - Mark.

 

[etaf]

you can sum them together sheets in 3D
they need to be together and you refer to the first and last - so assuming the first sheet is sunday and the last is Saturday - with mon-fri inbetween
Sunday:Saturday!A2
will sum all the sheets values in A2

back to your question
if you had
Monday , tuesday , etc
in the row in A1 ,A2 ,A3

you could use that in an indirect formula
=INDIRECT(A1&"!A1")
now when you copy down
the first A1 will change to A2, A3 etc
and if in those cells you have the text for Monday, Tuesday - it will refer to those sheet names

 

[Mark McInerney]

Makes perfect Sense - Never thought of it - Thanks for your time and help - greatly appreciated - Mark.