You are reading a single comment by @aggi and its replies. Click here to read the full conversation.
  • I suspect it may be quicker but whether or not it's worth it is a different matter.

    As part of the filter you can automatically have it copy to a new sheet automatically

    Range("A1:B15").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Range _
    ("A24:A25"), CopyToRange:=Range("Sheet3!A1"), Unique:=False
    

    I guess you can have the macro create the new sheets, rename them and then as you loop through copy to a new sheet each time.

About

Avatar for aggi @aggi started