Similar to Vlookup
 

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!

Similar to Vlookup
 

Have you looked at Data | Filter ?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mike" wrote in message
...
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!