Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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"? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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"? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically updating imported statistics | New Users to Excel | |||
why is excell not updating my formula data within a workbook? | Excel Worksheet Functions | |||
Formatting on imported data (Excel 2003) | Excel Discussion (Misc queries) | |||
Data table is not updating correctly in excel 2003 | Excel Discussion (Misc queries) | |||
UPDATING IMPORTED DATA | Excel Worksheet Functions |