Create sheets based on cell data

[Spawn-Swe]

Hello

This is my first post in this forum.

I have an excel file with five worksheets, sheet "WBS" shows the sheets to be created. In this sheet there are about 150 lines with different names of any sheets that can be created. The rows that determines whether the sheet is to be created is A2: A150 where I want to mark with an "x" if it should create a new sheet. Then I want the newly created sheet to be named after column B (In Sheet "WBS"), where all the names is described. Every new sheet shall be copied with cell data from worksheet "TEMPLATE". The rows where "x" is selected may contain blank cells aswell.

If possible, I want the macro to be dynamic so I can remove/add "x" in "WBS" and each time I run the macro it adds/removes sheets.

[Mumps1]

It is always easier to help and test possible solutions if we could work with your actual file. Perhaps you could upload a copy of your file to a free site such as www.box.com. or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do referring to specific cells and worksheets. If the workbook contains confidential information, you could replace it with generic data.

[Spawn-Swe]

I have put a stripped file on https://dl.dropboxusercontent.com/u/.../Test_WBS.xlsm which is showing the correct worksheets that is mentioned in first post. Hope this is useful for further help on this matter!

[Mumps1]

When you say

Every new sheet shall be copied with cell data from worksheet "TEMPLATE".

do you mean that you will first enter data into the TEMPLATE and then you want the TEMPLATE sheet copied with the added data and renamed according to column B in "WBS"? Also, can you clarify what you mean by

The rows where "x" is selected may contain blank cells aswell.

[Spawn-Swe]

When you say do you mean that you will first enter data into the TEMPLATE and then you want the TEMPLATE sheet copied with the added data and renamed according to column B in "WBS"?

On this issue i mean that all raw data, as shown in TEMPLATE, shall be copied inte the new worksheets. After being copied I will then enter the missing data. No additional entries shall be entered in the TEMPLATE before copy!

Also, can you clarify what you mean by

The rows where "x" is selected may contain blank cells aswell.

I mean that not all cells in column A1:A150 shall be marked with an "x". Only cells with "x" shall be copied.

[Mumps1]

Try:

Please Login or Register  to view this content.

[Spawn-Swe]

Perfect, worked like a charm! Thank you for the help!

Next step is to get the dynamic function working. If I remove a "x" in the list it should remov that worksheet and/or add a new if added a "x"

[Mumps1]

Let's try a different approach to see if it works the way you want. Copy and paste this macro into the worksheet code module. Do the following: right click the tab for your "WBS" sheet and click 'View Code'. Paste the macro into the empty code window that opens up.

Please Login or Register  to view this content.

Close the code window to return to your sheet. Place an 'x' in any cell in column A and exit the cell. The sheet will be created automatically. Next delete the 'x' and exit the cell and that sheet will be deleted.

[Spawn-Swe]

Even better then the first macro.
Thank you so much, an early christmas present!

[Mumps1]

You are very welcome and Merry Christmas.