Is there a function to use in Excel so that when a criteria is met in one column, it will copy the text from the adjacent box int he next column onto another sheet?
e.g. Column 1 has learning statements in. Column 2 has either (a) achieved or (t) target added in as an assessment next to the statement in Column 1.
I'd like the statements which have been identified as targets to automatically then copy onto a new sheet in the workbook.
