I have a worksheet which is updated regularly with a new line, working
from the top down. I would like to find worksheet function which can
return the value in the bottom cell of a column which is not blank, so
that this value can be used in another worksheet.

ie I want to be able to return the most recent value in a column at any
time.

I had hoped there would be a ready-made function for this, but it
appears not.

Any ideas?