I have an excel Basketball workbook with a list of players named Player 1, Player 2 etc. I have linked these names to other worksheets with the same Tab name (Player 1 etc.).
I would like to change the names on both the list and the Tabs without redoing the hyperlink. Is this possible? Any help would be greatly appreciated.