Hi all, I created a repair sheet that involves 47 cars each assigned a number. I have a command button that will add a new line to a table each time a car(s) need a repair. I would like to be able to auto filter the sheet based on the car number via a command button or message box to where I enter the number and it automatically will bring up each row with that specific number (which is located in the 3rd field or column) in it and hide the rest. Than once I complete my report I will need to undo the filter. Any help would be greatly appreciated!!