Updating Imported Data (Excell 2003)
 

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"?

Updating Imported Data (Excell 2003)
 

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))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"lambchop" wrote in message
...
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"?