Add Column & sheet with Button

Hello,
Can someone point me in the right direction?

Im looking to have a button that will do a few things.
-insert a new column (with the same formula as adjacent ones)
-fill in the value of cell on row 5 with the initials in cell "C20"

-create a new sheet (COPY OF EXISTING USER SHEET or a blank template from user sheet)
-rename the sheet with the initials in cell "C20"
-copy value of C21 into new sheet cell B1

- clear contents of MASTER cell C20 and C21


is all that even possible?
TIA.

Maybe:

Please Login or Register  to view this content.

ohhh thanks John, very very close.

it seems the new column add does not go on and on. it just seems to cycle adding one then another then copies over the first.

That code copies the current sheet, (I need it to copy one of the other sheets(maybe I could name the sheet to be copied as "USER"))
what line would I edit to choose a different sheet to copy?

any way to make the new sheet add at the end of the tabs?

thanks very much for your very clever assistance.

is it easier to always add a new column after column "I" copying the formula from column "I" as id does it? ?

once again I appreciate your help.

Please Login or Register  to view this content.

ive made some changes that seem to sort the copy sheet issues, BUT im still having problems with the copy/new column. it overwrites existing ones.

WOW.

That is nearly perfect.
unfortunately it is too complex for me to immediately understand how to make a very tiny tweak.
Can I have the users full name populated into the new sheets cell B2? (instead of just the initials?
Point me to what line would do that?
Would I need to add another variable like "d" and "find" the "name"??

Thank you so very much.

well that did it!

now to go try understand what all of your code does.
thank you again!!!

that will go A VERY LONG WAY to help my understanding. thanks again!!

John, could you help me a little further.

Ive updated the sheet quite a bit with more functionality (with lots of help)
see attached.

It all works as I want in the attached condition. BUT I want to now hide the "projects" and "template" sheets.
when I do that and try to add a new user it just overwrites the last tab instead of making a new one.

any ideas?

thanks

John,

My poor understanding ( I think maybe on the merge and un merge ) means ive messed something up.
I added a new Column A and Row 1 just to provide some white space.
But now new column add button does not add it at the end.

I tweaked the code but I think its the merged cells are stuffing it up.

Please Login or Register  to view this content.