• cell to return value in last cell in a column (2003)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » cell to return value in last cell in a column (2003)

    • This topic has 2 replies, 3 voices, and was last updated 20 years ago.
    Author
    Topic
    #420034

    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.

    Thanks!

    Viewing 1 reply thread
    Author
    Replies
    Viewing 1 reply thread
    Reply To: cell to return value in last cell in a column (2003)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: