For example, in Column A I have a list of Names. In Column B I have a formulas that references other cells to calculate a value associated with the Name in Column A. If I sort Column A alphabetically, the Names in Column A are rearranged, but the associated formulas in Column B do not move - so my values in Column B no longer match the correct name. How do I sort and keep the formulas associated with the Name? THANKS!