View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default Inserting rows, updating linked worksheet

Try using a formula that bases the the row from the Tracker sheet on
the row that the formula is in. For instance, if the formula below is
in row 12 of some sheet, the result of the formula would actually be
=Tracker!A12. If necessary add or subtract an offset number such as
&ROW()+2) if you need to adjust it. This should get you started.

=INDIRECT("Tracker!A"&ROW())

- John