The information gathered is for Communitic International to ensure the sending of the newsletter.
The information will be used subject to terms and conditions, for advertising purposes.
You reserve the right to access and change your personal data, aswell as the right to request its deletion within the limits permitted by law.
You can also review your targeting options. For more information, click this privacy policy
.
Not exactly what I was looking for, but it gave me an idea of how to write my own code.
So thanks for your reply, issue solved.
Best regards,
Trowa
I think all you would have to change is sheet names and this line
Selection.AutoFilter Field:=19, Criteria1:="=" & 1, Operator:=xlAnd
to
Selection.AutoFilter Field:=2, Criteria1:="=Completed", Operator:=xlAnd