Hello!

I have a tracking/managing spreadsheet.
Column A is for the status.
I need the entire row from sheet "Terminations" to be moved to new sheet "Processed Terminations" whenever "Complete is selected as the status.

Also, is there a way to auto select the status to be "Complete" when Column C (Completion Date) is filled.

Ex: Input 08/24/2018 in Column C (Completion Date) - which will change the status in Column A to "Complete" - which when then automatically move to the "Processed Terminations" sheet.

Thank you so much!! I have been looking for a script for this and they are all old, or have the selection to be "yes/no"