| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy rows from one worksheet automatically, ignore rows that are b
I am trying to figure out how to automatically copy rows (several columns)
from one worksheet to another and have Excel ignore the rows that have some columns that are blank. Some columns have pick lists, some are free form. Does anyone know how to do this? If ALL columns in the row contain information I want it to copy the row to another worksheet. If any of the columns are blank or do not contain any data within the row, I do not want it to copy. I don't want to manually copy the rows and delete the rows with blank columns. Any help is appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy rows automatically | Excel Discussion (Misc queries) | |||
| Automatically copy rows based on criteria | Excel Discussion (Misc queries) | |||
| Macro to automatically add rows and copy formulas | Excel Discussion (Misc queries) | |||
| Copy Rows to another Sheet Automatically | Excel Worksheet Functions | |||
| How to copy values in various rows automatically | Excel Discussion (Misc queries) | |||
Threaded Mode
