How do I move data completely from one sheet to another sheet once it meets a certain criteria?

New Contributor

Hi there! 

 

I'm trying to format a tracking sheet I'm working on in Excel (using Windows)

I want to pull a row (for example a task) from sheet 1 to sheet 2 once it's complete. Each sheet has the exact same table. Once I fill in "Complete" in column C on any task, how can it get pulled to sheet 2? 

 

(Example: Sheet 1 and Sheet 2 is identical)

Excel Example Photo.PNG

Essentially it would delete it/remove it from sheet one and move it to sheet two.

Any ideas?

 

Thanks!

0 Replies