I have a workbook of about 200+ sheets.
I need to rename all sheets.
The new names are under a sheet called Names.
Column "A" has old sheet names, Column "C" has new sheets names.
Is there a macro that can help with this.
Old sheet name 200, NEW sheet name 9AM
Old sheet name 201, NEW sheet name 10AM
Any help is appreciated.