Say you want the last value on Col B capptured use the following
=LOOKUP(99999999999999900000,B:B)

"bpiepgrass" wrote in message
...
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.