Moving records from worksheet to worksheet

[ReeceC952]

Hi,

I have a list of people in one worksheet with various information about them. I have a column that you can either select yes or no for. I would like for when you select yes, that person and their information gets transfered to a new worksheet.

Is there a way to do this?

Any help will be much appreciated,

ReeceC952

 

[Rijnsent]

Hi ReeceC952,
yes, you could do that. You could either do it by having a macro running on a button, so after you selected a bunch of yes, you press the button and all those records gets transferred. Otherwise, you could use something like this:

Private Sub Worksheet_Change(ByVal Target As Range)
    
    'Do nothing if more than one cell is changed or content deleted
    If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub
     
    If Target.Column = 4 Then
        If Target.Value = "yes" Then
            'Do something, copy or move data?
        Else
        End If
    End If
End Sub

Hope that gets you started,
Koen