Home |
Search |
Today's Posts |
#1
|
|||
|
|||
3D Arrays
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 |
#2
|
|||
|
|||
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! ================================================== === "DB" wrote in message ... 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 |
#3
|
|||
|
|||
RD this very well may be what I need to do. I think i was trying to make it
too complicated. Thanks!! DB "RagDyeR" wrote: 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! ================================================== === "DB" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with plotting a chart when using arrays as Values and Xvalues | Charts and Charting in Excel | |||
Two arrays need highlight duplicate in one of the array | Excel Worksheet Functions | |||
Confused about arrays and ranges in functions | Excel Worksheet Functions | |||
Comparing Arrays | Excel Discussion (Misc queries) | |||
How to use linest with variably sized data arrays? | Excel Worksheet Functions |