VBA transfer data (either Cut or Copy) from sheet 1 to sheet 2 based on specific cell data selection change

[TTena]

Ultimately what I am attempting to achieve is the following action: (based on the Selection made in the cells of Column M & N on Sheet 1):

(NOTE: Cells "M" and "N" have a drop-down: Blank, YES, or NO)

1) On Sheet 1: If Column "M" (SINGLE PROCESS COMPLETE) is "YES" and
If Column "N" (ENTIRE PROJECT COMPLETE) is "YES" THEN

Cut the Row - Move the Rows Up - Transfer Data to SHEET 2 (Beginning under the Top Row Labels and/or into the next clear row available)

AND

2) On Sheet 1: If Column "M" (SINGLE PROCESS COMPLETE) is "YES" and
If Column "N" (ENTIRE PROJECT COMPLETE) is "NO" THEN

Copy the Row - Transfer Data to SHEET 2 (Beginning under the Top Row Labels and/or into the next
clear row available)

I also want to make sure that any of the Transferred Data (Whether CUT or COPIED) into SHEET 2 Does Not Change if Data in SHEET 1 changes.

Help would be appreciated.... I have written many VBA Codes for this but none are working

 

[mumps]

When you say

I also want to make sure that any of the Transferred Data (Whether CUT or COPIED) into SHEET 2 Does Not Change if Data in SHEET 1 changes.

does that include changes to columns M and N?

 

[TTena]

Yes, because Column M is set so other processes can be completed for an entire Project, that is why I added Column N so that the project processes would continue without removing the row to sheet 2 and having to re-entering the project for every step within the poject.

 

[mumps]

When column M is "YES" and column N is "NO", the row gets copied to Sheet2. What happens when you then change the "NO" to "YES" in column N?

 

[TTena]

It then reverts to the first condition of the VBA Code and it is then Cut (and rows moved up) from Sheet 1 and transferred to Sheet 2

 

[mumps]

In order to try to make things work each row has to have a unique identifier such as a Project ID or Project Number. Do you have something like that in your data for each row? If you do, in which column is it? If you don't, can one be added?