Thanks for the reply, but I'm adding new data in a new cell each day. I'm needing my "reference cell" to display the last entry for that column. For instance if I have data in cells A1 thru A30 I want my "reference cell" to show the data in cell A30, but the next day there will be a new value...
This should be easy to do...but I seem to be forgetting how I guess. I have dataset where daily values are entered. I need to reference the last entry of my data to another cell. I want it to where when the data is entered, the new cell is updated automaticlly.
Thanks