Moving completed row to another worksheet

[Doehead]

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

 

[Pete_UK]

There is no function or formula which can move a row of data to another
sheet.

You would need a macro to do that if you would want it to be automatic, or
you could think about using Autofilter and do it manually.

Hope this helps.

Pete

 

[Doehead]

Thanks Pete I will do an autofilter as I have no idea how to make a macro. lol