I want to copy inf.from a row in worksheet to other worksheet in the same workbook.
Example
I get the a list of items in purchase order(worksheet in the same workbook) for differents vendors and I have in the workbook one worksheet for each vendor. I would like to copy each item to repective vendor worksheet as soon as I write the items and vendor in the purchase order.

Excuse my English!