Hello,

I have a sheet 8 columns wide and 50ish long. Based on a value on col. 2,
I'd like to copy the entire row to a new sheet.
Do be more specific, I have a sheet with current and past projects. The 2nd
column holds the value if the project is active, pending, closed etc. What I
want to do is search through the entire sheet, find which projects are active
and copy that entire row to a new sheet.
Any ideas about how should I tackle this? I tried hlookup and vlookup, but
they return a single value, not the entire row.
Thank you for your time.