Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub Copy_chains_to_other_sheet()
- ActiveSheet.Range("$A$1").AutoFilter Field:=8, Criteria1:="<>1", _
- Operator:=xlAnd
- ActiveSheet.Range("$A$1:$I$681").AutoFilter Field:=1, Criteria1:="=*antaris*" _
- , Operator:=xlAnd
- Range("A1").Select
- Range(Selection, Selection.End(xlDown)).Select
- Range(Selection, Selection.End(xlToRight)).Select
- Selection.Copy
- ActiveSheet.Next.Select
- ActiveSheet.Paste
- ActiveSheet.Range("$A$1").AutoFilter Field:=1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement