(2003) Conditional copying&pasting

Y

Yiannis

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.
 
E

Eduardo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying conditional formatting to entire sheet 3
Automatically Move Entire Row to Different worksheet 6
Copy and pasting values of filtered rows 1
Copying data to the next blank row 0
Conditional Formula 1
Still Another Copy-and-Paste Macro Problem 3
Reduce File size 2
Formula to copy data in one sheet to another 8

Top