VBA to cut row and paste in sepcified sheet based on value

[maggie_chen8609]

Hi there, experts!

I currently have a document that keeps track of all my projects - a project entered per row. Each project as one of the following statues (Column A): "Proposal", "Project", "Lost", "Closed"; I also have a sheet for each statues previously mentioned (total of 4 sheets). Since projects start from "Proposal", that's where we initially enter all the project information. However, as statues change, I would like the entire row to be copied and pasted to the appropriate sheet (based on its status change), then the row deleted from the "Proposal" sheet.

Below is the VBA I have for the "Proposal" sheet to move rows to the "Project" sheet when the status (Column A) changes to "Project":

Please Login or Register  to view this content.

I'm having trouble setting up this action for other statues. Can anyone help me out, please?

Once a row is moved to its appropriate sheet, it can also move to OTHER sheets from that point (Example. from "Project" to "Complete" - that being said, can I use the same VBA code for all the sheets?


Thanks,
Maggie

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[alansidman]

In order to identify the particular project that you have now reclassified on the "Project" Sheet, it must have some sort of unique identifier in both the master and the "Project" sheet. What is that identifier. Which column is it located in? Without it, it will be nearly impossible to determine which line to remove from the "Project" Sheet. A sample workbook uploaded would assist in resolving this.