How can I link a cell to another? What i mean is how can i link cell A6 to B6? Say for example i arranged column B alpphabetically, and then cell B6 moved to cell B1 (as it was arranged aplhabetically), is there anyway i could get cell A6 to move to cell A1 aswell?

Thanks for any help