Auto populating cell values from list based on criteria (Source: Dynamic separate excel file)

[Johnelbek]

Dear all,

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

 

[Akashwani]

Hi and welcome to MrExcel.

Take a look here and see if this helps to point you in the right direction........

Excel Magic Trick 356: Dynamic Two-Way Look Form Different Workbook - YouTube

I hope that helps.

Ak