linking worksheets

J

j van c

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

Hi
just link the first cell
e.g. ='sheet1'!A1
and copy this formula for your range. The reference will adapt
automatically
 
Top