Hi,
Why don't use filter then in order to copy the information filtered do, CTRL
G, Special, Visible cells only, copy, and then paste in your new sheet

"Yiannis" wrote:

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.