Dynamic report based on user input

[C02C04]

I’m 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 I’m really
bad at it. Any suggestions?

 

[Eduardo]

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

 

[C02C04]

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]

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]

All the options to show up at once.

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

 

[Eduardo]

So, let's say you have the table as follow
Sheet2 Column A: Origin, Region, destination & Miles
Sheet2 Column B, c, d, Etc the information related to Region, destination &
miles(your example, column B will be Asia, mumbai, 10000)
En Sheet1 you want to pull this information when an origin is selected let's
say in A
in A2 you will right Region, in A3 Destination, in A4 data(miles)
in B2 enter this formula
=+VLOOKUP($A2,Sheet2!$A$:$F$,2,FALSE), then in C2 Change the 2 for 3, and so

 

[C02C04]

Hi Eduardo

Thanks for your quick reply.

I need to elborate the data setup. My sheet A has 3 columns: Origin,
Destination, Destination Region. Sheet B has Origin, Destination, Destination
Region and Miles (to keep things simple). Sheet B is raw data and un-sorted
and I do not want user to see that. I had sheet A in sorted manner and
concatenate them to create unique identifier. This may be redundant if there
is a better to do it straight out of Sheet B.

The output below is to enable user to easily pick up miles from Sheet B and
then perform further calculation.

The challenge I faced is to manage the changing/dynamic destinations and
organizing them in the order of Asia, EMEA and US. Hope this brings clarity
and see where my problem is.

 

[Eduardo]

Hi
please do something I don't need real information just give me a complete
example on what do you want to do with your raw data, I feel that I am
missing something that is why I request it