Thanks for the response. After reading it, I realized my example was
incorrect, and like you mentioned C3+C4 becomes C4+C5. I just mixed up
columns and rows.

The VLOOKUP Formula will probably be effective, but I will not be the one
creating the formulas, I am just creating the source data. I could train the
user on the VLOOKUP formula, but it will probably be too complicated for
them. Maybe creating a macro using the VLOOKUP formula would be the answer.

Thanks for your help!

"Dick Kusleika" wrote:

Chris

When I use formulas that refer to external data, I try to design them so
that it doesn't matter how the data is sorted or changed. Where you have
=C3+C4, I may have

=VLOOKUP(D10,external_data,3,False)+VLOOKUP(D11,ex ternal_data,3,False)

although that works better when your formula deals with one record at a
time. Yours seems to be dealing with a certain record and the one below it.
And if you insert a row, your formula should change to =C4+C5. Only when
you insert a column would C change to D.

You also might want to read this

http://www.dicks-blog.com/archives/2...rties-options/

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Chris wrote:
I have a spreadsheet that pulls data from a SQL view. There will be
other spreadsheets that use the values in these query cells. The
problem I am having is when a new row gets added to the view, it
doesn't go to the bottom (as it shouldn't) and thus gets "inserted"
into the appropriate part of the spreadsheet. The problem is that
since no actual "insert" is performed, the formulas get screwed up
because any record below the new one gets bumped down, but the
formulas don't get updated appropriately.

Ex

I have a formula that says =C3+C4

I want the formula to get the specific information in that spot. If I
wasn't using a database query, and needed to insert a row above it, I
would insert the new row and the formula would get updated to be
=D3+D4, which is what I want. However, when the database query adds a
new row, the formula stays at =C3+C4.

Anybody have ways around this?