Linking question
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 |
Linking question
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. -- Regards, Tom Ogilvy "Joanne" wrote: 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 |
All times are GMT +1. The time now is 11:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com