XL2000 - Linking Named Ranges

  • Thread starter Thread starter LPS
  • Start date Start date
L

LPS

Tom Hutchins helped me tremendously when he suggested I link two workbooks
by using named ranges. Problem now is I don't remember how to do that and I
can't find the reference in "Help".

Could someone please jog my memory as to how to link a named range in one
workbook to another workbook so that it automatically updates when changes
are made? This is very urgent.

Thx,
 
It's just like linking to a group of cells in another workbook. Easiest way
to set it up initially is to have the other book open and start typing the
linking formula by entering = and perhaps a function in the cell that is to
link to the other book, like:

=SUM(
then just reference the other book and range name like
=SUM(Book1.xls!RangeName)
and it's done. When you close "Book1.xls" the formula will update to
include the path. By having it open, it saves you from having to type it all
in.
 
Back
Top