I need the sheet to match the location selected from the drop-down box when I construct a macro that creates a new sheet inside of my excel file.
When you click Button 1, a new sheet appears but I don't know how to name is the same as the selected name. This is my code so far:
I must substitute the health authority I chose from the drop-down box for "newname."
The name is already stored, as you can see because I copied it. I was considering utilizing a paste spatial value as a potential solution, but I'm not sure how to do it.