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...