Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
(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
Posted to microsoft.public.excel.misc
|
|||
|
|||
(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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional copying&pasting (2003) | Excel Discussion (Misc queries) | |||
Copying and Pasting Print Format in Excel 2003 | Excel Discussion (Misc queries) | |||
Copying and pasting | Excel Discussion (Misc queries) | |||
Copying and Pasting | Excel Discussion (Misc queries) | |||
Copying and pasting ??? | Excel Discussion (Misc queries) |