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.