(2003) Conditional copying&pasting
 

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.

(2003) Conditional copying&pasting
 

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.