Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional copying&pasting (2003)
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 | |||
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) | |||
Copying and Pasting | Excel Discussion (Misc queries) |