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)
Essentially it would delete it/remove it from sheet one and move it to sheet two.