Formulas loosing cell reference

[hmjjohnson]

Formulas loosing cell reference

The spreadsheet works in Excel 2000 when you open it in any newer version it is corrupted. Which is fine so we are rewriting it in Excel 2010/2013.

We have data in columns A:E which comes from the refreshable query. Data in F:I are different formulas based on the data from the query. The number of rows we get will vary from query to query. The headers never change just the data. How can we make it so that when no matter the data length the formulas will always autofill up or down depending on the data length?

The image is what I think is different from the old excel to the new excel.


http://s1360.photobucket.com/user/Ja...bc497.jpg.html

[Tony Valko]

Maybe you need to use dynamic ranges:

http://contextures.com/xlNames01.html#Dynamic