Updating Imported Data (Excell 2003)

  • Thread starter Thread starter lambchop
  • Start date Start date
L

lambchop

Everytime I update an imported file if there are any changes in it's length
it causes #REF! errors in my formulas that point to it. Is there a way for
the formula to always point to a specific cell irregardless if it the
contents get "moved"?
 
If you use a formula something like this:

='Sheet 1'!A7

And you want it to *always* point to A7, even if rows are inserted or
deleted
above it,
try something like this:

=INDIRECT("'Sheet 1'!A7")

However, the above formula *can't* be copied down to *automatically*
increment the rows.

For that sort of functionality, you'll need something like this:

=INDIRECT("'Sheet 1'!A"&ROWS($1:7))
 
Back
Top