Moving rows of data to multiple sheets based on status for project pipeline

Hi all,

I'm having an issue moving data between tables on different sheets. I have a project pipeline report that needs to move row data between different sheets as the projects change status. It's going to get rather large and have multiple hands in it so I want to try to automate it as much as possible. The three sheets are Pipeline, In Progress, and Completed. All data will be added on the pipeline sheet but as the status changes I'd like that row to be deleted from the pipeline and put on the the proper sheet depending on the status. The status mapping is below

Pipeline - Queued
In Progress - In Progress, On Hold, Delayed
Completed - Completed

In turn it would be great if when the status was changed from In Progress to Completed it would delete it from the In Progress sheet and add it to the completed sheet.

I took a look through the forums and found and found a bunch of great posts but since I'm new to VBA I'm having trouble translating that code into something for this sheet. Any help would be greatly appreciated. I attached my sample spreadsheet for reference.

Thanks!

Hi there,

Maybe something like this?

I'm pretty new to VBA as well but thought I'd give this a shot. I think I have the basic concept down of what you're looking for. Check it out and let me know.

If anything, it's a good start until someone who has more experience can tackle it.

Thanks this did the trick!