Linking question

  • Thread starter Thread starter Joanne
  • Start date Start date
J

Joanne

using excel 2003

Can excel link worksheets by an entire named range on each ws instead of
setting up cell to cell links?

Thanks for the info
Joanne
 
Let us say I have a named range TEST which refers to sheet1 and covers Range
A1:D10

If I go into another sheet, select A1:D10 (exact same area/location, but in
another sheet), go to the formula bar and enter =TEST and hit CTRL + Enter,
then it does link to the respective cells.

If I go to another part of the sheet and select a comparable area, I need to
do an Array entry

=TEST CTrl+Shift+Enter

and it will work.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Worksheet name to each begining of each row with values 2
Search other sheets for numbers & color them 10
VBA code for pasting links -- modifying RDB code for summary workbook 10
Select Case Code does not run... 10
Copy a range data from 1 sheet to multiple selected sheets 1
Problem in adding macro to ribbon through Add-in 7
Macro for Multiple Worksheets 6
paste transpose 3

Back
Top