Hi guys,
In desperate need of some help from you kind strangers.
I need a helping editing my code that MOVES (not copies) a row of data from one work sheet to another depending on what a cell in the STATUS column says.
E.G: Cell in (Column7"Status") = Remove -> I want the row of data to then move to "Delete" sheet.
E.G 2: Cell in (Column7"Status") of Improvement WIP sheet says "Complete" = Move to Workstack -> I want the row of data to then move to "Improvement Workstack" sheet.
I would like to apply this code to each seperate sheet, so then once a job is completed in WIP i can select status as "Complete" and move it to delete, OR if it is to be put on HOLD I can select "Move to Workstack" to move the row to the appropriate sheet.
My workbook:
Sheet 1: Improvement WIP
Sheet 2: Improvement Workstack
Sheet 3: Inbound WIP
Sheet 4: Inbound Workstack
Sheet 5: Delete
Column Names in every sheet:
Col1: Work Item
Col2: Service
Col3: Related Priority
Col4: Owner
Col5: Role
Col6: Objective
Col7: Status
Col8: Target Date
1) I currently have the following code which allows me to perform the action for COMPLETE, however I want the code to also apply the same rule for a status that says "Delete" (Move any row with the status "Remove" to the "Delete" sheet).
2) Currently the code only copies the data but instead I would like it to cut the data.
Current Code:
Bookmarks