Is there a forumla to link an absolute cell reference in multiple.

[Thomas]

I have an ablsolute cell reference (for example Cell A1) on 10 different
sheets in my workbook.

I want to know if theres a formula I can copy down that will pull cell A1
from each of the sheets. Is there a way to do this without manually clicking
the cell on each sheet?

 

[JulieD]

Hi Thomas

what are your sheet names? (an example of 2 or 3 will do)

Cheers
JulieD

 

[RagDyeR]

If your sheets have the default XL names, you could try this:

=INDIRECT("sheet"&ROW(A1)&"!A1")

And drag down to copy.

To simply add them together, try this:

=SUM(Sheet1:Sheet10!A1)

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have an ablsolute cell reference (for example Cell A1) on 10 different
sheets in my workbook.

I want to know if theres a formula I can copy down that will pull cell A1
from each of the sheets. Is there a way to do this without manually
clicking
the cell on each sheet?