I have a spreadsheet with several columns of data. Each day we add a number to the bottom of column D. Is there a way for cell A1 to display the number in the last cell in column D.. and update to match when we add new data to end of the column? For instance, today the last cell in column D may be D400. Tomorrow it will be D401 and I need A1 to reflect the value in D400 today and D401 tomorrow.
Probably simple. But it escapes me.