I would like to have a Macro that generates a new tab and names that tab based on a cell value.
There is a tab called
'Dashboard'! on which the user enters information in assigned cells. Afterwards, I would like there to be a button that the user clicks, upon which the information from the
'Dashboard'! is copied to a new sheet. That new sheet should be given the name that the user has entered in cell
B2 (the name of the day) and cell
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 shows up in the Macro perfectly. I do not know, however, how to make this name 'dynamic'.
Thanks in advance for any help, apologies in advance if this question is redundant and/or phrased inadequately.