add new sheet

My code is supposed to create a new sheet for each entry that is marked in a list of task codes. This is how it is supposed to function. In my workbook I have a list of task codes. For each task code I've left a space for the user to indicate which task codes the user wants to create a sheet...

Hi! I am am looking for some much needed help but please bear with me as I am a complete novice and only joined Mrexcel today! Using windows 7 with Excel 2013 but would like this to run on previous versions also. The following is what I would ideally like: I have a workbook with 2 worksheets...

I have a button with a macro assigned. The macro needs to create a new worksheet at the end of the workbook, rename the new sheet to "New County", make the cell size match the rest of the workbook, and then paste in a template from another sheet called "Master". I recorded a macro that does...

Hi Everyone, I am new to excel programming. I found a great example of a similiar macro on this site that copies sheet1 from all files in this directory. I would like to add a couple of new features to this code: 1). I would like the user to browse to a directory for the source files. (I have...

Hi all, I am trying to create a loop to add multiple worksheets I want to add a new sheet for each company (A2:A14) This is what I have so far, not sure how far off I am. Can anyone help? I am also wanting to add the sheets after the current last sheet if possible. Sub addnewsheet() x =...