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:

[TABLE="width: 379"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Airport Name[/TD]
[TD]IATA
Code[/TD]
[/TR]
[TR]
[TD]Adelaide International Airport[/TD]
[TD]ADL
[/TD]
[/TR]
[TR]
[TD]Bendigo Airport[/TD]
[TD]BXG[/TD]
[/TR]
[TR]
[TD]Brisbane International Airport[/TD]
[TD]BNE[/TD]
[/TR]
[TR]
[TD]Canberra International Airport[/TD]
[TD]CBR
[/TD]
[/TR]
</tbody>[/TABLE]

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!