Hi,

Please help. I apologize, I know this has been addressed in previous posts but they just don't seem to work.
I have several sheets in a workbook, two particular to this post. Sheet 1 is "Current job list" and Sheet 4 is "Completed job list", rows 3 the first 2 rows are column titles, Column Q is % completed as soon as a the cell value in column Q is 100% in Sheet 1(from row 3 onward) then it needs to automatically copy the entire row (formulas, drop down list, etc.) to the top of list of completed jobs (i.e. from row 3) in Sheet 4. Then, if the the cell value in column Q in sheet 4 is not 100% the cell automatically copy the entire row to the next empty row in Sheet 1.

Any guidance or advice would be greatly appreciated.