I am trying to find a way to auto populate cells (either entire row or individial columns) based on criteria value in a dropdown list.
The source data is located in a separate excel file. This excel file is generated from a database and will update monthly. The column headers will remain the same always.

The criteria lists will be made in the "City", "Product", "Indication" fields in the Customer tool file. So basically, if I choose "City" the data from the Database.xls file corresponding to city should be displayed in the area below in the Customer tool.

Both files can be downloaded from here:

http://basbous.dk/test/customertool.xls
http://basbous.dk/test/database.xls


I am thinking autofilter with some kind of macro to take care of the dynamic source list?
I am not sure how to go about this