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
|