Linking Ranges

T

TangentMemory

Is there a way to link ranges from one worksheet to another? I have a named
range called Utilities in cells A2:D6. Is there a way to link "Utilities" to
a different worksheet in cells B13:E17?

Thanks
 
D

Duke Carey

Select cells B13:E17. Type "=" and press Ctrl-F6 until the workbook with the
named range is active. Press F3 and select Utilities. Press Ctrl-Shift_Enter
 
E

Earl Kiosterud

Tangent;

Select B3:E18. Type =Utilities (or press F3 and choose it from the list of
names). Press Ctrl-Shift-Enter. It will create an array formula.
 
T

TangentMemory

Thanks, that worked. That leads me to another question...

Once I have copied the cells, is there any way to add a row in the original
worksheet and have that update in the copied worksheet? So let's say I need
to add a row in between 3 and 4. I do so, now my copied cells only show
A3:new cell:D5. Row 6 is not shown unless I drag the formula down to row 18
on the copied worksheet.

I just want to have the copied worksheet add a row when I do the same on the
original spreadsheet.
 
E

Earl Kiosterud

Tan,

The named range could use the Dynamic Range technique, shown in various
Excel web sites.
 
Top