3D Arrays

D

DB

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
 
R

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
 
D

DB

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

Thanks!!

DB
 
Top