After constant searching the forum, I've encountered different ways where the sheet tab name changes automatically using Macro depending on a certain cell value.
However, it doesn't seem to work (maybe because the cell value) changes between the categories under the listed data validation dropdown. I'm really not sure though...
Could anyone help me here?
ECR1.xlsm
Bookmarks