Hi everyone,
I'm hoping someone might be able to help me.

Column C has a possible text of "Enrolled", "Failed" or "Discontinued"
Column E has possible text including:
"Visit 1 (Week 1)"
"Visit 1 (week 2)" etc
"Visit 2 (week 1)"
"Visit 2 (Week 2)" etc
all the way up to "Visit 22 (Week 52)" as well as other text which is not related to my question such as "Early Termination".
I need to build a macro to filter column C for "Enrolled" and then filter column E for everything that starts with "Visit 7" up to "Visit 22". I then need to delete all those remaining rows (Enrolled Visit 7+) and then remove the filters to show everything remaining.

I hope this makes sense to someone! Feel free to let me know if you need any more information.

Many thanks
Stuart