| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make all values of a 3D named range appear on summary sheet
Hi All, I have a 3D named range (across 145 woksheets). I can use that for
sum, average etc but is it possible to make all the values appear on a summary sheet?. I am trying with 3D but also open to other ways. So I have values on H42 on 145 sheets - how to make them link quickly to a summary sheet (so I do not have to make a formula linking each H42 to the summary sheet Thanks in advance for any ideas Joe |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet Names is Defined by Cell value on Sheet 1 (named Summary | Excel Discussion (Misc queries) | |||
| Sum values in columns based on values in named range | Excel Worksheet Functions | |||
| combining values and text to make a reference for "named range" | Excel Worksheet Functions | |||
| How to make a dynamic named range | Excel Discussion (Misc queries) | |||
| Can I make a list, on one summary sheet, of data collected from ma | Excel Worksheet Functions | |||
Threaded Mode
