I have a simple inventory list as shown in table A1:D8. The user enters the quantity required in column E. I would like these chosen items to appear in a second set of tables according to the Category of the product.

The double criteria is confusing me (non-zero Qty and category). Any helpers?

Regards, Paul

Extract Data.png