Hi @ Webbers

About the trigger:
For example if J3-J6 are All listed as Completed, then rows 2-8 are moved to Projects_Completed tab.
Perhaps you mean K3-K6 (yellow highlighted) marked as Complete ?
If all 4 cells in column K for each project are marked as Complete...then it means the project is complete...no need to check the status in columns C,E,G,I ?