I have a userform which creates a new sheet using TextBox2.value as the sheet name.
Here is the code I am using and it works fine.
Here is the problem - After additional code is run on the newly created sheet I need to take the value (Which will be text) from cell AM6 of the newly created sheet and place it on an activecell on Sheet3. Seems simple enough but I do not know how to address this new sheet as I do not know what the name will be.
Here is the code I have tried (and various renditions of it)
I do not want to specifically name the new sheet as many sheets could be created, unless you could tell me a way to do that.
Any help would be appreciated,
Thanks
Ed