I have Text Boxes that I would like to move based on the values in Column A. The values in Column A change as new data is added. What I would like is for the Text Boxes to move the correct row based on the value in Column A. The lookup values for Column A will come from a Named Range/Table. To help clarify, I have names in Column A with new names added regularly that are sorted alphabetically. I have a separate list of some of those names that have a Text Box(es) associated with it. As the new names are added, I would like the text box(es) to move with the name. The The Text Boxes are in Columns for eg. E & F. The reason I am using Text Boxes is because the data itself is in a Pivot table. As the Pivot Table grows with new names, I want the Text Boxes to follow.