Hello
Somehow the below coding does not result for exact Autofilter execution
The Above Syntax only shows one record of only one manager in Wks2 and not the records of other managers as per the List range in column A2: A11 of wks1
The Manager Names are also there in wks2 colunm D to match the Criteria List Name of Managers as per Wks1
Kindly Help me to achieve what i desire
Thanks
NimishK
Somehow the below coding does not result for exact Autofilter execution
VBA Code:
Private Sub AFM_NotFunctioning_As Per_Expectation ()
Dim wks1 As Worksheet, wks2 As Worksheet, wks3 As Worksheet
Dim lastUsdRowWks2 AS Long, lastUsdRowWks1 AS Long
Dim MangrsNameArr As Variant
Set Wks1 = Worksheets("MANAGER NAMES")
Set wks2 = Worksheets("PYMNTS")
lastUsdRowWks2 = wks2.Range("A" & Rows.Count).End(xlUp).Row
lastUsdRowWks1 = wks1.Range("A" & Rows.Count).End(xlUp).Row
MangrsNameArr = Wks1.Range("A2:A11").Value
wks2.Range("A1:K1").AutoFilter Field:=4, Criteria1:=MangrsNameArr, Operator:=xlFilterValues
End Sub
The Manager Names are also there in wks2 colunm D to match the Criteria List Name of Managers as per Wks1
Kindly Help me to achieve what i desire
Thanks
NimishK