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

Jim Rech's suggestion is the easiest one I can think of. Just about anything
else that I can think of would require some VBA coding. His method would
definitely easily deal with edited data in the source range, although it
wouldn't necessarily deal with inserted/deleted cells/rows/columns in the
source range - as I'm certain both he and you are aware, that's just the
nature of the beast.

"John" wrote:

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