Hi ,
I am trying to copy values from one sheet to another on the bases of a particular column.
For eg : I have a worksheet with three sheets A,B and C... i want to copy the rows of Sheet A to Sheet B if the value of the columns = PL . If the value is anything other than PL then the row value should be copied to Sheet C.
I am attching the sample file which should be the result.
Pls help