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