Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
moving empty rows down a list
I use a formula that looks for certain citeria, then copies that data to a
new spreadsheet. However, it leaves empty rows in the new spreadsheet if the criteria isn't found. Is there a way of moving these empty rows down the spreadsheet, but still leaving the formula intact, so if it is run again and the criteria is found it will still copy the needed data. I know i can filter it, but was wondering if there was an automatic way to do it, like a macro ? Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
How do I sort with empty rows between none empty rows? | Excel Worksheet Functions | |||
How to pick one or more items out of a list, moving to new list, moving up or down. (form) | Excel Discussion (Misc queries) | |||
Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
Can Excel "slide up" rows with content thru empty rows to condense | Excel Worksheet Functions |