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!

It's not clear what you're trying to filter. Can you show some sample
data, and the results you'd like to get?

Havenstar wrote:
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!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Sure....the first column is protected so they are unable to change the 2nd
column they can either put yes, no or leave blank. What I want to do is sort
with the Yes's from both columns, then the no's and blanks to another
location.

Standard
Documentation Optional Required Description
Yes Manual Set Up Time
Yes Owners General Instructions
Yes Bill of Materials-Mechanical
Yes Spare Parts List & Pricing
Yes Mill / Material Test Reports
No Supplied Component Manuals
Yes Main Assembly "As-built" Dwgs
ASME Manufacturers Data Report

This list is in excel and we then copy and past into a word document and
send to the customer documentation requiremenst (Yes') and the other items
are optional (No and Blanks')

Hope this helps!
Havenstar

"Debra Dalgleish" wrote:

It's not clear what you're trying to filter. Can you show some sample
data, and the results you'd like to get?

Havenstar wrote:
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!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

You could copy the list to another sheet, and add a column to calculate
if there is a Yes in the row:

=IF(COUNTIF(A2:B2,"Yes"),1,2)

Sort on the new column, then you could delete the column.

Havenstar wrote:
Sure....the first column is protected so they are unable to change the 2nd
column they can either put yes, no or leave blank. What I want to do is sort
with the Yes's from both columns, then the no's and blanks to another
location.

Standard
Documentation Optional Required Description
Yes Manual Set Up Time
Yes Owners General Instructions
Yes Bill of Materials-Mechanical
Yes Spare Parts List & Pricing
Yes Mill / Material Test Reports
No Supplied Component Manuals
Yes Main Assembly "As-built" Dwgs
ASME Manufacturers Data Report

This list is in excel and we then copy and past into a word document and
send to the customer documentation requiremenst (Yes') and the other items
are optional (No and Blanks')

Hope this helps!
Havenstar

"Debra Dalgleish" wrote:


It's not clear what you're trying to filter. Can you show some sample
data, and the results you'd like to get?

Havenstar wrote:

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!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html