is it possible for excel to automatically copy a row to another sheet of that
workbook based on the value of a column?

for example, if i want to copy row 19 from sheet 1 to row 19 on sheet 2,
based on the column K having the value inputted as 'yes'?
--
- Rich