How do I display lines depnding on a cell critrera

Try Autofilter. DataFilterAutofilter

Imp: Do not leave your message area blank. Ever. Always use it to re-explain
& elaborate on your query. The subject line's just that, its not meant to be
the entire posting. Do note that responders using the same MS webpage (as
you) to read/respond will NOT be able to respond to any post with blank
message area (it's a technical glitch). So inadvertently, you're shutting
them out from helping you.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000, Files:362, Subscribers:62
xdemechanik
---