Hi all,

Is there a formula to automatically move (not copy) a row of completed data
to a different sheet in the same workbook. I want to move all data in a row
as long as there is a specific value of Y in Column F.

For example, Sheet 1 (Outstanding) my columns are (A-H):-
Case ID, Last Name, First Name, Facility, Surgeon Name, Case Completed,
Procedure Name and Postponed. Sheet 2 is called Completed.

Thanks,


Thanks