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

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

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.