On Fri, 14 Oct 2005 02:15:04 -0700, "DavidBr318"
wrote:

I wish to have Excel choos items from another worksheet according to the
criteria I set (ie: if =1, then choose ... but skip if not = 1 and select the
next item = to 1 ...) I can set this up so it replicates the other worksheet
- but I end up with a lot of blank lines - I don't want the lines blank - but
only have lines with information = to my querry.

Thanks,
David

Have you tried Data Filter Advanced?

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________