Excel search by entering single or multiple criteria | VBA | Macros Please Help!

Hello!

I am very, very new to VBA and am trying to create a vehicle lookup document that will allow the user to search by single or multi criteria. The user just enters the information they want to search by, hit the search button and the results would show up under the search fields. For example, the user could enter a year range (1990 - 1993), Vehicle Make (Porsche) and they would see all 1990-1993 Porsche's including other information about each vehicle. The search function is on one sheet and my data is on another.

Any help is greatly appreciated. Thank you!

Thank you so much for taking the time to help me!

This is super cool!

Thank you, Mehmetcik! This is so amazing and you've been very helpful. I truly appreciate all your time.

Is it pretty easy to add additional columns? For example, a column for VIN (Vehicle Identification Number) and street address. Also, I will need to update the data on a monthly basis, how big of a deal is it to update the data? I will be doing that on a monthly basis. Also, is there a way to automatically run the macro when the file is opened or maybe just link a launch button?

Thanks again