Linking cells into other sheets - Latest update only


Is there a way to link a cell from one sheet to another, but only link over the latest change from changed cell?


Best Answer

  • Lee Joramo
    Lee Joramo ✭✭✭✭✭✭
    Answer ✓

    Still not sure about this, but it does sound like you have a cell that contains multiple lines of text, and not multiple rows in the same column. Lets say the following is in Column "Notes" and Row 1

    01/25/24: New Hard Drive installed

    01/12/24: After investigation, hard drive noted as issue. Replacement purchased.

    01/04/24: Customer states issue with computer.

    If the lines are split by a "New Line" Character, we need a way to find the "New Line" Character. We can do this by using the CHAR function. A New Line character should be CHAR(10)

    We can now get the first line by using this formula:

    =LEFT([Notes]1, FIND(CHAR(10), [Notes]1))

    which returns 01/25/24: New Hard Drive installed