Cut entire rows to another sheet

[juannava]

I would like help in this, I have a list of projects in several rows and at the column "K" is the status of the project, according to the status of the projects if the status is completed I want cut this entire rows and paste to another sheet calls Projects_Completed by using a macro

Thanks in advance =)

 

[VoG]

Hello and welcome to MrExcel.

Do you want a macro to run this as a 'batch' or to transfer the row as soon as "completed" is entered in column K?

 

[juannava]

Thanks for the welcome

Well for me this will be work better as soon "Completed" is entered at the column "K" or, by clicking a button the macro scan all the data and searching for completed projects this means column K as "Completed" and if it match cut this rows and the others who meet this criteria, and paste to the other sheet

 

[juannava]

Hello and welcome to MrExcel.

Do you want a macro to run this as a 'batch' or to transfer the row as soon as "completed" is entered in column K?

Thanks for the welcome

 

[VoG]

Try this: right click the tab of the sheet where you will enter Completed, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
Dim LR As Long
If Target.Count > 1 Then Exit Sub
If Target.Column = 11 And LCase(Target.Value) = "completed" Then
    Application.EnableEvents = False
    With Sheets("Projects_Completed")
        LR = .Range("A" & Rows.Count).End(xlUp).Row
        Target.EntireRow.Copy Destination:=.Range("A" & LR + 1)
        Target.EntireRow.Delete
        Application.CutCopyMode = False
        Application.EnableEvents = True
    End With
End If
End Sub

Now, if you enter Completed in column K the whole row should be transferred to Projects_Completed.

 

[juannava]

So amazing

thanks for the help i'm really apreciate this, it works very well

 

[lgroulx2000]

Hi,

I would like to try this code. I followed the instructions but can't get it to work. Any ideas?

Larry

 

[VoG]

Hi,

I would like to try this code. I followed the instructions but can't get it to work. Any ideas?

Larry

Are macros enabled? Tools > Macro > Macro Security.

 

[lgroulx2000]

Hi,

Macros will run. I can't believe how much information (and experts) there is on this site. I'm try out many bits of code to learn how to improve my excel knowledge.

I just can't get this one to run.

Thanks,

Larry

 

[VoG]

Did you place the code in the worksheet code module? Right click the sheet tab, select View Code and paste the code in there.