Results 1 to 36 of 36

Add or Update Worksheets based on Column Status from Master Data to Another Sheet

Threaded View

  1. #10
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,056

    Re: Add or Update Worksheets based on Column Status from Master Data to Another Sheet

    Try the attached version. The error when deleting or copying rows should now be fixed. The macro works in the following manner:
    In the APPLICATION sheet:
    - If you add any new status, the new sheet will be created and the row of data will be copied to it.
    - If you change any existing status to a name that does not have an existing corresponding sheet, the new sheet will be created and the row of data will be moved to the new sheet.
    - If you change any existing status to a name that has an existing corresponding sheet, the row of data will be moved to the existing corresponding sheet.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 12-26-2019, 06:45 AM
  2. Replies: 2
    Last Post: 07-06-2018, 11:52 AM
  3. [SOLVED] Create new worksheets from master sheet based on column contents. Only copy certain fields
    By gbt17 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2017, 12:51 PM
  4. VBA to Update status Column based on recent date
    By edkawy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2017, 10:06 AM
  5. Split data into multiple worksheets based upon a column in master worksheet
    By cep3927 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2014, 10:38 AM
  6. Copying (but not deleting) data from a master sheet to multiple worksheets based on Col A
    By SmartBalance in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2013, 03:09 PM
  7. [SOLVED] VBA to create many worksheets from one master sheet based on column value
    By Ironman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2012, 02:47 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