linking worksheets
Yep. The easy way to do it is to start in the 'target' cell, where you want
the info to end up. Type an = sign to start the formula, then simply navigate
to the cell(s) where the source data is on the other pages. Click on them
and either use them directly or in a formula.
The formula in the target page (say, it's 'Sheet2') will look like this.
Note the single quotes and exclamation point:
='Sheet1'!A1
or
= 2 * 'Sheet11'!A1
HTH
" wrote:
Is there a way to dynamicly link worksheets, such that new inserted
lines in the source sheet are also added to the linked sheet?
|