Move completed rows to another sheet, and parts need to the bottom sheet.

Hello!!
I am trying to create this spreadsheet and am not very familiar with macros at all or if it is possible to do this not using a macro at all. I am using Excel 2003, I would like to move rows that are completed in the Daily schedule to the completed worksheet based on the information in column O (completed yes or no). I would then like to move rows to the bottom of the Daily schedule based on the information in column T and highlight it as well. I created drop down list but am unsure that this would make it possible for me to do this or affect what I need. Any ideas please help. I have attached the spreadsheet

Thanks !!!
Sherryp