I have created an advanced filter using the first two columns which contain
"Yes" to copy to another location. Now they would like me to take the
remaining items which would contain "No" or be blank" after the Yes items.
Not sure how to update the criteria range. Right now I have;

Standard Documentation "Yes" if Optional Required
Yes
Yes

Can anyone advise how to bring in the other items after the Yes's.

Thanks
Havenstar!