Ghostbuster_one
New Member
- Joined
- Mar 11, 2022
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
hi all
i am wondering how i can make the criteria in my advance filter flexible. I now have data added up to row D5, but it might as well be only row D4 or D1 and D2.
How can i get it to read lines that are populated ?
Many thanks!
Ralph
Sub ADV()
'
' ADV Macro
'
'i am in file 2
Cells.Advancedfilter Action:=xlFilterInPlace, CriteriaRange:=Workbooks( _
"File 1.xlsm"). _
Sheets("List of Acc. - Resp.").Range("A1:AD5"), Unique:=False
Windows( _
"File1.xlsm"). _
Activate
End Sub
i am wondering how i can make the criteria in my advance filter flexible. I now have data added up to row D5, but it might as well be only row D4 or D1 and D2.
How can i get it to read lines that are populated ?
Many thanks!
Ralph
Sub ADV()
'
' ADV Macro
'
'i am in file 2
Cells.Advancedfilter Action:=xlFilterInPlace, CriteriaRange:=Workbooks( _
"File 1.xlsm"). _
Sheets("List of Acc. - Resp.").Range("A1:AD5"), Unique:=False
Windows( _
"File1.xlsm"). _
Activate
End Sub