Good morning
I am creating a template worksheet that will be duplicated numerous times in the future, and i want to be able to use a cell reference to change the name of the worksheet rather than manually renaming the sheet each time.
So in the attached example .... if i have a value in cell A1 that i can choose from a data validation list, i then want the sheet name to reflect the same as is in this cell.
I am assuming a short VBA code would be the best approach, and that it would need to be triggered on changing that sells value?
If anyone has any idea it would be much appreciated.
The aim is to create the sheet in a way that I can duplicate it (as a master) and then as I change the cell value it renamers the sheet.
Bookmarks