Macro Help for Filtering

[Jeremy]

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.

 

[john]

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.

 

[Norman Jones]

Hi Jeremy,

Further to John's suggestion, if you need
a macro solution, try turning on the macro
recorder while you follow the
recommended Advanced Filter steps.

This will provide you with base code
which may be edited to provide a generic
routine.

If you expereience difficulties with such
editing, post your code and indicate the
specific problems.

If, however, a VBA solution is not
mandatory, consider downloading
Ron de Bruin's excellent EasyFilter Add-In,
which may be downloaded, as freeware,
at:

EasyFilter Add-In
http://www.rondebruin.nl/easyfilter.htm