I am using a workbook as an order form for inventory. I have a macro that copies all the Items that were entered on the order form to a Item Master Sheet. Another Macro then removes any duplicate items. When I fill out a new order form and start typing in the item, I want excel to auto-populate the item name if it is on the Item Master list. Is this possible?