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