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.