How would I get the following to work? I have a list and was hoping to check if a worksheet name has a match in Column A of the list and get the corresponding in B.
At the moment, all I can think of is doing it name by name.
Sheets("One").Name = "OneNewOne"
Only issue is it might get rather long and I might miss something. Can someone please help?