I have a database of vehicle information (3000 rows by 20 columns) for cars that are at several different facilities. What I am trying to do is have a single facility # be selected from a drop-down list and in return an array of cells will be filled in with the information from the database that corresponds to that facility # only (approx. 30 rows by 20 columns).

I have the feeling that I will have to use VBA to get what I need, but have no idea where to start on finding the coding that is going to work.

Any help is greatly appreciated!