Copy cells based on multiple criteria

[kingconsto]

Hello,

I am trying to get a excel formula or macro that will allow me to extract specific fields from an excel table given 2 criteria (filtering). For example, I would like to only look at data in Column B whose criteria whould be "Boats" and filter column E to only show those fields that are integers (no letters allowed). I would then copy the corresponding data from Column D and column H and paste it to another existing sheet. I can explain further if this isn't making sense.

Thanks!

 

[kingconsto]

I have the following but it only fits for one criteria (I have 2, the other being in cloumn E) and when the data copies, it just pastes over the last data and doesn't continue on the next row.

Sub copyrows()
     
    Dim tfCol As Range, Cell As Object
     
    Set tfCol = Sheets("D.AFS").Range("B8:B400") 'Substitute with the range which includes your True/False values
     
    For Each Cell In tfCol
         
        If IsEmpty(Cell) Then
            Exit Sub
        End If
         
        If Cell.Value = "LMA_CZK_AFS_CFH" Then
            Cell.EntireRow.Copy
            Sheets("NPV").Select 'Substitute with your
            RowCount = Cells(Cells.Rows.Count, "A").End(xlUp).Row
            Range("A" & RowCount + 1).Select
            'ActiveSheet.Range("A80").End(xlUp).Select
            'Selection.Offset(1, 0).Select
            ActiveSheet.Paste
        End If
         
    Next
     
End Sub