I currently have a spreadsheet that simply consists of data that I dump in it
from another internet based application. From there I have a second
worksheet that references certain columns/rows in the first spreadsheet to
extract just the data I need. The next worksheet I have ranks the
information and then displays it in an organized fashion on a different
worksheet. The situation I am running into is that the data I extract from
the internet based application can have a different # of rows based on the
day I pull it and my formulas only work if the # of rows on the first sheet
are the same. For instance, if I have 700 rows today and I pull it tomorrow
and there are 701, the 701st row is not taken into consideration when ranking
the data and therefore my information displayed is incorrect. Is there a way
to have my reference cells recognize there is an extra row and update all my
formulas to account for the extra row as well??