Gerry
You could use a helper column to decide whether or not these conditions are
true (or false) and filter on true.
=OR(AND(LEFT(n2,1)="J",RIGHT(N2,1)="N"),AND(LEFT(N2,1)<>"J",RIGHT(N2,1)="Y"))
Entered in the helper column and copied down use a label Test in N1
Hope this helps
Peter
> Can someone write me a wee snippit of VBA which I can attach to a
> button. I would like to be able to click a button with would run a
[quoted text clipped - 7 lines]
>
> Many thanks