Hi Mark,
Probably should have pointed you to this to start with
Excel Filters -- Advanced Filter
http://www.contextures.com/xladvfilter01.html

Filters are fun to work with, when you copy and paste from
a filtered list all you pick up is what is not filtered out, and
Mail Merge (MS Word) only see the filtered list.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"mark_b2410" wrote in message
This isn't help but...
Can you hide rows/cells using conditional formatting?