Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy if
Hi,
I have a workbook where I want to copy data from one sheet to another sheet based on a columns criteria. If Worksheet_1, column A has the value 13-2006, I want all the rows that contain this value to populate the empty Worksheet_2. How do I write the if statement to make this happen? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy if
Hey All,
I'm looking for the same type of formula, that if a vaue in a column meets a certain criteria, it will copy the entire row into another sheet. "fascal" wrote: Hi, I have a workbook where I want to copy data from one sheet to another sheet based on a columns criteria. If Worksheet_1, column A has the value 13-2006, I want all the rows that contain this value to populate the empty Worksheet_2. How do I write the if statement to make this happen? Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy if
Hi,
I believe that it is the VLOOKUP function that is part of the equation. I just cannot figure out how to incorporate it with copying those records that meet criteria to a specified worksheet. "stevieboy1313" wrote: Hey All, I'm looking for the same type of formula, that if a vaue in a column meets a certain criteria, it will copy the entire row into another sheet. "fascal" wrote: Hi, I have a workbook where I want to copy data from one sheet to another sheet based on a columns criteria. If Worksheet_1, column A has the value 13-2006, I want all the rows that contain this value to populate the empty Worksheet_2. How do I write the if statement to make this happen? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Cut & Copy then restore on exiting | Excel Discussion (Misc queries) | |||
Copy tabs(sheets) from workbook without link to original source | Excel Discussion (Misc queries) | |||
Copy shortcut | Excel Worksheet Functions | |||
How can I copy cell formats in functions? | Excel Worksheet Functions | |||
Copy without Hidden Cols - How | Excel Discussion (Misc queries) |