| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy rows to new sheet based on specific cell value
Is it possible to copy an entire row to a new workbook based on a specific
cell's value? Specifically, if the cell contains a "1" I would like the entire row to be copied to a new workbook. I know this can be done manually by sorting, copying and pasting, but the file is large and there are a few hundred rows that meet the criteria weekly. Any help is appreciated - it now takes a considerable amount of time to do this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find and copy rows based on specific criteria? | New Users to Excel | |||
| Search for rows in one sheet and copy into another sheet based on customer id | Excel Worksheet Functions | |||
| Copy rows to new sheet based cell reference, not value | Excel Discussion (Misc queries) | |||
| Copy rows from one sheet to another based on a cell value | Excel Worksheet Functions | |||
| Copy rows from one sheet to another based on a cell value | New Users to Excel | |||
Threaded Mode
