+ Reply to Thread
Results 1 to 2 of 2

Create sheets based on cell data

  1. #1
    Registered User
    Join Date
    06-15-2016
    Location
    Sweden
    MS-Off Ver
    2010
    Posts
    9

    Create sheets based on cell data

    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.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello Spawn-Swe,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. create sheets based on cell values with corresponding data
    By VinodN in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-29-2016, 07:16 AM
  2. [SOLVED] VBA: Create new sheets based on cell value and copy data
    By Metrazal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2015, 07:33 PM
  3. [SOLVED] Create sheets based on Cell A name
    By Christopherdj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-05-2015, 04:24 AM
  4. [SOLVED] Filter data on sheet1, create, and paste into new sheets based on cell value
    By minister in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2013, 09:16 PM
  5. [SOLVED] Create new sheets based on template from master sheet data/information?
    By jlaurnm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-13-2012, 08:09 PM
  6. Create pivot automatically in all the sheets based on the data in sheets
    By aravindhan_31 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-29-2008, 11:59 AM
  7. [SOLVED] CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA
    By control freak in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-20-2006, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1