I came across this post yesterday about searching using a string

http://www.excelforum.com/excel-prog...rd-phrase.html
The workbook from response 12

So here's what I am trying to do. I have 2 worksheets, "Orders" and "Search". "Orders" has the info for all branch's inventories and their recomended orders or shipouts based on the amount that they should have in their store. What I am trying to do on the "search" page is search to see if another branch needs to sell off something that we need to order so we can easily recycle our items instead of shipping them out to the regional warehouse.

Here's the technical aspect of it. On the "Search" sheet there are 3 fields, Item Code (A3), Amount (B3), and Type(meaning Shipout or Order)(C3). Right now I'm using the autofilter method to filter the "Orders" sheet in column D for the Item Code selected from a drop down menu (Validation not Form) in Sheets("Search").Range("A3"). Then with the filtered range I sort xlDescending column J if its a "shipout" and column K if its an "order". Then I copy that to the "Search" sheet starting in cell A14. Then I select/delete the rows that don't meet the "Amount" in Sheets("Search").Range("B3").

With the linked workbook above, I see a good potential for something that is much more efficient in design. My question is this: Can I adapt the linked Macro to account for multiple criteria such as this?