I have a colum of data that I update each day with yesterdays number (i.e I
add data below the previous day each day)

I want to set a formula to always grab the last day of data that I have
entered in this colum. The final cell in that colum that contains any data.

I want to do this so that it can populate a calculation on another sheet
showing how much a the total of this colum increased yesterday so that I can
calculate yesterdays contibution to the running total.

Thanks for your help.