You can use this formula to find the row number of the last entry in column A

=MATCH(9.99999999999999E+307,A:A)

Once you have the row number, you can pull any item from that row into your
second spreadsheet using the INDEX() function, i.e.,

=INDEX(Sheet1!A1:Z500,MATCH(9.99999999999999E+307, A:A),2)

to get the value in the 2d column (column B) of that row





"Justin C" wrote:

I'm adding one row of data to a table each day, the first column is the
date. On another worksheet in the same workbook I'd like to show a
calculation based on the most recent data only, the data on the second
worksheet is mainly static apart from a daily update based on the new
figures.

Any suggestions on how to go about this?

Thank you for any help you can give.

Justin.

--
Justin C by the sea.