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
|