View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael[_4_] Michael[_4_] is offline
external usenet poster
 
Posts: 27
Default 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