Try using datafilterautofilter

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"bkunes" wrote in message
...
i have done a search and assigned either a 1 or a 0 to each row, 1's are
matches. i want to create a sort that will take all the matches and all
their coressponding data in each adjacent column to the top of the sheet.
so
in other word if there is a 1 move the entire row to the top of the sheet.
however, i cannot use the <data, <sort option because i need the sort to
be
automatic, because i will be completeing different searches often,
therefore
data will change frequently.


A B C D
E F
0 SC677-0001-54.63 26.3125 2 0.5 45/45
0 SC704-0001-54.63 27.3125 0 3 90/90
1 SC862-0001-54.63 27.3125 0 3 90/90
0 SC884-0001-54.63 27.3125 0 0.375 45/45
1 SC917-0001-77.76 38.88125 0 0 90/90

thanks in advance
--