reference named range

[Michael]

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

 

[Peter T]

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]

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







- Show quoted text -

Perfect. Thank you.