Hello sir NeedForExcel. is it possible the result is in Sheet 1 not in the other sheet sir ?? and is it possible to change the quantity into 1 when the result is paste sir ? i wish you can help me sit.. GODBLESS.