Hi I have a table of information that has a list of Surnames in Column B and Column U, I need to be able to type a surname into the textbox and search by clicking the command button, resulting in the rows featuring the surname in either column will only appear. Plus when the textbox is left blank it will show all data again. Thanks, hope this makes sense.