Excel: Copy certain row to new sheet

Dear all, i would like to copy each new order start from row "PH Order No:" to "0" to new sheet. for below example, i would like to separate 4 order to 4 sheet. Please help!!! [IMG]http://i58.tinypic.com/21kkobd.jpg[/IMG]

This question generated 25 answers. To proceed to the answers, click here.

This thread is current as of June 17, 2014.

For more resources for Microsoft Excel