title: I need an entire row copied to a new sheet if value of certain column on Sheet 1 = x
body: <p>We are currently using a shared excel workbook to track inventory in a small business. Sheet "Inventory List" lists each product with price, vendor, cost, etc. There is also a column we have created to mark an "x" if we need to order the product. Therefore, if there is an "x" in that column (column E) that whole row would then be copied and pasted into a new sheet. On this new sheet I would like them to be organized by vendor which is column P on Inventory List. Please let me know if you can help. Thank you.</p>