If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
(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. |
#2
|
|||
|
|||
(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. |
Thread Tools | |
Display Modes | |
|
|