Hello all, need a little help!

[LucasCu]

Hi there,

I'm new here, and I will begin my journey into Excel by asking a quick (and probably simple) question.

I am currently setting up a database on global airports and I have an issue with two columns that I want to remain linked.

For example:

Airport Name	IATA Code
Adelaide International Airport	ADL
Bendigo Airport	BXG
Brisbane International Airport	BNE
Canberra International Airport	CBR

<colgroup><col><col></colgroup><tbody>
</tbody>

Once my database is complete, I want to be able to sort the data I have entered, but as the IATA code is directly connected to the airport, I want the two columns to be sorted together. In the eventuality that someone wishes to sort airports A-Z, I want the IATA code to be sorted with it.

I'm a beginner with excel, and any help is much appreciated!

Kind regards

Lucas

 

[x65140]

Airport Name in column A, IATA code in B
Highlight both columns at the top
Click on DATA
Click on SORT
Sort by Column A
This will sort the Airports A-Z (default) - but you can change the order as well...

 

[LucasCu]

Thank you for your help!