A macro that creates a sheet as I add names

GingerJohn - Apr 12, 2015 at 03:38 PM
I am an absolute nocie when in comes to VBA and wondered if anyone can help. I am trying to create a macro that will copy a new name entered in one sheet, rename a worksheet under that name, put the new name in to a list and then copy a template on to the sheet I have just created. E.G. 1.On Sheet 1 I enter my name "John". 2. It takes "John", creates a worksheet and titles it "John". 3. From Sheet called "template" it copies all information and pastes that to sheet "John". 4. It takes sheet "John" and copies it in to an already existing list of names so that the rest of my sheets can refer to it. I know its a long shot but like I said im at a loss. Thanks anyone who can help.