Can someone assist me with the below? I have aExcel 2010 and sheet that has the following data:
First Name | Last Name | Email | Role
There are around 10,000 rows. Essentially I want to make excel search the 'Role' Column and everytime it finds the following pre-defined cases 'business development' ' bus. dev' 'Business Development' ' Business Dev. 'sales' ' Sales' it should copy the full row to a separate sheet? It essentially is a filter but the inbuilt filter for Excel 2010 doesn't seem to allow me to filter on multiple criteria?
Thanks
Bookmarks