I recommend you copy all the data to the new sheet. Sort column (A, B, both?) and delete any rows that have a zero (they should all be together and easy to find). If the original order is important, then create a helper column which you initially number 1 to ? before any sorting/deleting. Then do the sorting and deleting as above, then sort the helper column (and you can then erase the helper column).