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

Copper Contributor

Hi there! 

 

I'm trying to format a tracking sheet I'm working on!

I want to pull a row (for example a task) from sheet 1 to sheet 2 once it's complete. 

 

EX: Column K is my "Final Status" column, and once I input "Completed" I'd like to to pull the entire row to sheet two. So it would completely remove it from sheet one. I only want to see in progress tasks on sheet one and completed tasks on sheet 2. 

 

Any ideas?

 

Thank you!

1 Reply

@DestinyT3 

With your permission, if I may recommend, add a file (without sensitive data) and use this file to describe your problem step by step, or add photos with the appropriate description.  

You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.

Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).

 

Don't forget no one in this forum can see what you see.

In this link you will find some more information about it:

Welcome to your Excel discussion space!

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)