I have a data base that I want to search where if I type Sm* it will bring up all of the last names that start with Sm. also useing the same cell I would like to be able to search lot numbers and sales order numbers. I have a data set, please tell me what or where I need to add for someone can help me with the VBA code.