Advertisement
Guest User

Untitled

a guest
Nov 27th, 2014
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. Sub Copy_chains_to_other_sheet()
  2. ActiveSheet.Range("$A$1").AutoFilter Field:=8, Criteria1:="<>1", _
  3. Operator:=xlAnd
  4. ActiveSheet.Range("$A$1:$I$681").AutoFilter Field:=1, Criteria1:="=*antaris*" _
  5. , Operator:=xlAnd
  6. Range("A1").Select
  7. Range(Selection, Selection.End(xlDown)).Select
  8. Range(Selection, Selection.End(xlToRight)).Select
  9. Selection.Copy
  10. ActiveSheet.Next.Select
  11. ActiveSheet.Paste
  12. ActiveSheet.Range("$A$1").AutoFilter Field:=1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement