Here is a sample workbook which represents my actual workbook pretty good.
I am using a macro to loop through two comboboxes and store the value of metric A and metric B in a new worksheet called Score.
Is is the table in Score that I want to analyze and find the best combination of cities.
