View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Getting a named range to appear in another worksheet

How do I do this?

Typically by linking formulas but this is so basic I'm not sure if you're
looking for something else.

Anyway, the easiest way to create these formulas is to copy the source
range, go to the first cell where you want the links and do an Edit, Paste
Special, Paste Link.

--
Jim
"John" wrote in message
...
I have a named range of data in one work sheet that I want to automatically
populate a range of the same size in another worksheet in the same
workbook,
so that when items change in the first, they appear updated in the second.

How do I do this?

Thx for your help, John