+ Reply to Thread
Results 1 to 5 of 5

Create and polpulate new sheets based on data sheet and master sheet.

  1. #1
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    368

    Create and polpulate new sheets based on data sheet and master sheet.

    Good Day Everyone

    I have a workbook with a "Master" sheet and a "Data" Sheet, what i need is a macro that will create new sheets copied from the master sheet(duplicated) based on the values in column E2:E of the "Data" sheet and each new sheet named for said values.

    i.e. if "Data" sheet column E2 is abc123, then a new sheet identical to the "Master" sheet named abc123 needs to be created and if E3 in data sheet is 123abc, then a new sheet identical to the "Master" sheet named 123abc needs to be created etc.

    then the values in the newly created sheet needs to match the rest of the row where the name of the sheet was derived from.

    i.e. sheet abc123 range C6 value must be equal to "DATA"A2
    sheet abc123 range C7 value must be equal to "DATA"C2
    sheet abc123 range C8 value must be equal to "DATA"B2
    sheet abc123 range C6 value must be equal to "DATA"A2

    .....and

    sheet 123abc range C6 value must be equal to "DATA"A3
    sheet 123abc range C7 value must be equal to "DATA"C3
    sheet 123abc range C8 value must be equal to "DATA"B3
    sheet 123abc range C6 value must be equal to "DATA"A3

    The rest of the data pre entered into the "Master" sheet must also be duplicated to all new sheets.

    i.e. if i put "test a 1 " into range A18 of the master sheet, then all the new sheets must have the same in A18.

    Any help here will be greatly appreciated.

    Thanks in advance.

    see attached my sample workbook.....
    Attached Files Attached Files
    Last edited by ANDREAAS; 06-09-2019 at 01:35 PM.

  2. #2
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Create and polpulate new sheets based on data sheet and master sheet.

    I couldn't open the file link, but maybe this is what you want.

    Please Login or Register  to view this content.
    Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
    Just when I think I am smart, I learn something new!

  3. #3
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    368

    Re: Create and polpulate new sheets based on data sheet and master sheet.

    Thank you very much Whiz. works a charm.

    When it creates the new sheets though......it does not maintain the column widths and row heights of the master sheet.....how do we go about fixing that?

  4. #4
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow

    Hi !

    Better is to use Worksheets.Copy method, easy so see in VBA inner help …

  5. #5
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    368

    Re: Create and polpulate new sheets based on data sheet and master sheet.

    thank you Marc.

+ 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. Need help how to setup code to create new sheets to a template based on a master sheet
    By Badassfullsize in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-19-2015, 11:15 PM
  2. [SOLVED] Create new sheets from master sheet based on multiple column criteria
    By hamidxa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2015, 02:44 PM
  3. How to create and populate sheets based upon cell values in master sheet?
    By mezzopiano1423 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2013, 12:51 PM
  4. [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
  5. create sheets' data from master sheet
    By ShadowRider in forum Excel General
    Replies: 9
    Last Post: 10-17-2010, 03:23 AM
  6. Create sheets based on a column of master sheet
    By samdaddy07 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-10-2009, 02:54 PM
  7. Macro to create new sheets from master data sheet
    By adsigel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2006, 09:21 AM

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