'Copy if statement

I would like to copy the values from the "BALANCE" column from the nostra tab if it meets the BANK condition in the NAME column. Is this code going in the right direction?

With wbMe.Sheets("nostra")
    .AutoFilterMode = False
    With .Range("A1:I11")
        .AutoFilter Field:=1, Criteria1:="Bank "
        .SpecialCells(xlCellTypeVisible).Copy Destination:=wbMe.Sheets("papiery").Range("A5")
End With

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Copy if statement

Sources

Related Questions