Results 1 to 17 of 17

Create Copies of a Worksheet Based on a Range with a Set Criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Create Copies of a Worksheet Based on a Range with a Set Criteria

    I have a workbook containing two worksheets, the first worksheet called 'Summary' contains an ID in column A and a Status in column B. The second worksheet called 'Template' would be hidden (I've left it unhidden in the attached sample) is effectively a template which would have numerous cells containing various different formulas.

    What I would like to be able to do is have a macro activated by a button on the 'Summary' worksheet that when run creates a new worksheet for every ID in column A that has the corresponding status of 'Complete' in column B.

    The newly created worksheet name should match those IDs. I also then need cell C5 to be populated with the corresponding ID on each newly created worksheet, so e.g. when the macro is run, a copy of the 'Template' worksheet would be created with the worksheet named AB124 and cell C5 will have AB124 entered in it and likewise for every instance where the ID in column A shows 'Complete' in column B. So in the attached sample when the macro is run it will create 15 copies of the hidden worksheet 'Template' (leaving 'the 'Template' worksheet hidden), each one named according to the IDs in column A showing 'Complete' in column B and each with the corresponding ID entered into cell C5.

    Is this actually possible to achieve?

    Many thanks
    Attached Files Attached Files
    Thanks,
    HangMan

    You can say "Thank you!" by clicking Add Reputation below the post.
    Please, mark your thread [SOLVED] if you are happy with the solution.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Create worksheets copies based on Textbox value
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-12-2015, 12:04 PM
  2. [SOLVED] Create worksheet based on range
    By jockywilson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-20-2014, 10:41 AM
  3. [SOLVED] Create Range Name Based on 3 Criteria
    By Maroota in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-16-2014, 03:24 PM
  4. Create windows folders based on range criteria
    By renden in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2013, 11:44 AM
  5. How do I create a macro which hide dates, copies information to another worksheet?
    By naixiaki in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2010, 07:49 AM
  6. Create Copies Of Worksheet Based On Range Value
    By SamuelT in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-02-2009, 12:07 PM
  7. create copies of a worksheet using VBA
    By Back2Basics in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2009, 12:08 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