hi
Let's say it choose London, he has to choose one of the regions option and
cities in order to get the milage, or you want all the options to show up at
once

"C02C04" wrote:

Hi Eduardo

User can select from a dropdown list of unique origin (selected London as an
input). The output is shown below with Region, Destination and Data on the
left and the result are the right. Hope this clarify.


"Eduardo" wrote:

Hi,
Could you give me an example of user imput and which result you would like,
thanks

"C02C04" wrote:

Im hoping someone could help.

Scenario
I have data on airline routes €“ origin, destination and destination region.
For example, origin might be London, one of the destinations is Mumbai and
destination region is Asia. I have created unique origin that user can
select. I would like to create a dynamic report that list the destination and
its region based on user input.

Origin=London
Region Asia Asia EMEA US
Destination Mumbai Malaysia Spain Texas
Data(miles) 10000 15000 2000 20000

There will be instances where a region will not have any destination. The
order would be Asia, EMEA and US for region. Origin, destination and
destination region are on a same data sheet.

I very much prefer to use to use logic/formula instead of VBA as Im really
bad at it. Any suggestions?