Excel Skills? Completely OT

Posted on
  • I haven't done this in along time and searching is just giving me conflicting answers.
    If a Cell in one column
    something along the lines of
    If Sheet 1 B1= Sheet 2 B1 then copy Sheet 2 Row 1 to Sheet 1 Row 1

    Sheet 2 Row 1 to Sheet 1 Row 1 - This would be 4 colums at the end of the row.

  • i love a bit of concatenation myself

  • i love a bit of concatenation myself

    I've spent about 2 hours this morning concatenating crap with simple formulas.
    I hate this time of year.

  • Anyone know if you can use O365 Typescript or whatever it's new scripting language is to add a timestamp to a column when another column's value is changed?

    The 3rd comment here on a similar request suggests not possible ("There currently is no way to trigger a script run on cell/range change.")

    https://stackoverflow.com/questions/70175029/dynamic-office-script-date-for-modified-row

  • Post a reply
    • Bold
    • Italics
    • Link
    • Image
    • List
    • Quote
    • code
    • Preview
About

Excel Skills? Completely OT

Posted by Avatar for Scrapper @Scrapper

Actions