3D Arrays

[Guest]

I know there is a way to select arrays on different sheets one array at a
time. Is there is a way to select arrays (located in the exact same cell
range) on different sheets collectively? I'm trying to set up a template and
only need to doe this once but there will be in excess of 100 sheet tabs.

Thanks for your help.

DB

 

[RagDyeR]

Don't know if I quite understand what you mean, but does something like this
help:

=AVERAGE(Sheet1:Sheet5!A1:A5)

=SUM(Sheet25:Sheet100!A1:A5)

?
--

HTH,

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

I know there is a way to select arrays on different sheets one array at a
time. Is there is a way to select arrays (located in the exact same cell
range) on different sheets collectively? I'm trying to set up a template
and
only need to doe this once but there will be in excess of 100 sheet tabs.

Thanks for your help.

DB

 

[Guest]

RD this very well may be what I need to do. I think i was trying to make it
too complicated.

Thanks!!

DB