Is there any way to automatically update formulas referring to my data when I delete or add a row to my data?
1 Answer
Take a look at lists (XL 2003) or tables (XL 2007 & 2010). These add the type of functionality you're talking about and may work for you.
Also, you could add a named range to your worksheet with a relative reference that refers to the cell directly above. You could modify the example on this page under the heading "Using relative references."
2*A2
in cell A1 and insert a row in between then cell A1 will read2*A3
, i.e. formulas are updated automatically. What else do you want?