Hi everyone,

I am trying to figure out a way to do a couple of things, and I hope that
you can help me!

First, I'm trying to find a way to do something similar to the vlookup
command except I want it to return multiple rows of information into another
worksheet. Basically, I want to have one worksheet that will return the
results of every row that has a cell with the value "Complete" in the other
worksheet. Does that explain it?

Second, this might be a little harder, and hopefully I can explain it good
enough. I am wondering if there is a way to automatically colapse rows if
they have no information in them. I am wanting to have a couple of headers,
and I want the information to automatically reference (with the vlookup
similar comand), but when the list gets smaller, I want my headers to
collapse and fill in the empty spaces. Is there a way to set up a
conditional setting that will hide the rows when there isn't anything in them?

Anything to help me out will be greatly appreciated!