Guys ! I have a macro at the bottom that I would like it to find me the BANK criteria and copy the value from the SALDO column to Destination. How to modify the code so that after searching it copies data from the column SALDO ? 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

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA filter and copy result

Thread starter Palucci
Start date Jan 11, 2022

Status: Not open for further replies.

Palucci

Banned user

Jan 11, 2022

Guys !
I have a macro at the bottom that I would like it to find me the BANK criteria and copy the value from the SALDO column to Destination. How to modify the code so that after searching it copies data from the column SALDO ?

VBA Code:

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