I want to create an acronym table (with terms listed alphabetically based on the abbreviation), with column A containing the abbreviation, and column B containing the full term.
What I want to do is link cells across a given row, e.g. A2 & B2, A11 & B11, so that when new terms are added, and I sort alphabetically, the appropriate explanation will be tied to the appropriate abbreviation.
So, when a new term is added into column A and its explanation is added into column B, I can sort alphabetically without mixing up abbreviations and their appropriate full terms.