Have a look at this site: http://www.contextures.com/xladvfilter01.html
It's got all you need to know to get you started & you can download for free
- working examples.
--
jb


"Jeremy" wrote:

I am horrible at programming, but learning. Can someone help me write a
simple macro to sort all items in where H2 (and on down) is NO and B2 (and on
down) Is Non blank (this field is picked from a validation List).

I want to assign this to a button.