I am trying to create a worksheet for my salesguys.

They have a list of 897 items to choose from (plant cultivars, sizes etc.) I would like them to put how many plants they need in column E, then I would like Excel to copy and paste any number that is larger than 0 to another worksheet, that I could give to the supervisor and purchase the plant stock.

How do I do this?

Thanks in advance!

Chris