View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pdberger pdberger is offline
external usenet poster
 
Posts: 258
Default 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?