Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reference named range
Is there a way to reference a 10x10 named range to get all the data to
appear on another sheet? I am thinking of somethign like an array formula that will allow me to reproduce a table on another sheet. It seems to work with just range name if it is a one dimentional but is dependent being in the same row or col on the other sheet. Is there a way to do this for 2D tables without same row/cols. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
reference named range
Select cells same size as your named range and simply array enter your name
as the formula, =myName ctrl+shift+enter Personally I'd rather simply link the cells instead of the array formula, PasteSpecial Paste Link Regards, Peter T "Michael" wrote in message ... Is there a way to reference a 10x10 named range to get all the data to appear on another sheet? I am thinking of somethign like an array formula that will allow me to reproduce a table on another sheet. It seems to work with just range name if it is a one dimentional but is dependent being in the same row or col on the other sheet. Is there a way to do this for 2D tables without same row/cols. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
reference named range
On Aug 18, 11:12*am, "Peter T" <peter_t@discussions wrote:
Select cells same size as your named range and simply array enter your name as the formula, =myName ctrl+shift+enter Personally I'd rather simply link the cells instead of the array formula, PasteSpecial Paste Link Regards, Peter T "Michael" wrote in message ... Is there a way to reference a 10x10 named range to get all the data to appear on another sheet? I am thinking of somethign like an array formula that will allow me to reproduce a table on another sheet. It seems to work with just range name if it is a one dimentional but is dependent being in the same row or col on the other sheet. Is there a way to do this for 2D tables without same row/cols. Thanks- Hide quoted text - - Show quoted text - Perfect. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combox Box - Need to Reference Named Range | Excel Programming | |||
reference first cell in a named range | Excel Worksheet Functions | |||
automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
named range, offset self-reference | Excel Discussion (Misc queries) | |||
Reference a named range | Excel Programming |