rearrangement based on matching text in excel? : I will try and keep this as simple as possible. I have a list of names (first, last) in one column (A), then I get a second list which is usually about a quarter of the list in column A. **I want the cells in column b (the short list) to automatically rearrange so that the names are next to the name that matches in column A**. If there is anyone nice enough to tell me, if this match happens how I would go about getting the word present to be entered in the very next Column corresponding to the name on another sheet in the same work book, PLEASE. Thank You in advance for help.