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. These 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 one post like this http://www.excelforum.com/excel-prog...ell-value.html but I'm still having some issues. Any help would be greatly appreciated. I attached my sample spreadsheet for reference.
Thanks!
Bookmarks