I currently have workbook that has an UserInput sheet where a user will enter order numbers in cells A2:A33 that they are interested in.
They then can use a macro to import data from a different database. This data that has been imported has all the orders for the last 6 months. How can I use the range on the sheet "UserInput" to search for those orders on the new "output-2" sheet and delete all the other orders?
Should I create an array for the range A2:A33? Then how do I keep only those orders we are interested in?
Thanks in advance for your help,