J j van c Mar 3, 2004 #1 I know ho to link cells to oher cells. But is there a convenient way to link ranges or worksheets to others.
I know ho to link cells to oher cells. But is there a convenient way to link ranges or worksheets to others.
F Frank Kabel Mar 3, 2004 #2 Hi just link the first cell e.g. ='sheet1'!A1 and copy this formula for your range. The reference will adapt automatically
Hi just link the first cell e.g. ='sheet1'!A1 and copy this formula for your range. The reference will adapt automatically