I would like to have a Macro that generates a new tab and name that tab based on a cell value.
There is a tab called
'Dashboard'! in which the user enters information in the assigned cells. Next, I would like there to be a button on which the user clicks, on which the information on the
'Dashboard'! it is copied to a new leaf. That new sheet must receive the name that the user has entered in the cell
B2 (the name of the day) and cell phone
C2 (the date of that day), followed by the word
I have successfully recorded a Macro that does most of this, but naming the new tab based on a cell value seems impossible. I have manually changed the name of the tab, which is perfectly displayed in the Macro. However, I don't know how to make this name. & # 39; dynamic & # 39;.
Thanks in advance for any help, sorry in advance if this question is redundant and / or is improperly worded.