Results 1 to 13 of 13

Create a new Worksheet for each subtotal from master worksheet

Threaded View

trudukeblu1973 Create a new Worksheet for... 03-22-2022, 10:08 AM
CheeseSandwich Re: Create a new Worksheet... 03-22-2022, 11:27 AM
Marc L Hello, try this ! 03-22-2022, 08:21 PM
trudukeblu1973 Re: Create a new Worksheet... 04-14-2022, 06:01 PM
Marc L Re: Create a new Worksheet... 04-14-2022, 08:09 PM
jindon Re: Create a new Worksheet... 04-14-2022, 10:19 PM
trudukeblu1973 Re: Create a new Worksheet... 04-15-2022, 12:40 PM
jindon Re: Create a new Worksheet... 04-15-2022, 10:29 PM
Marc L Try this ! 04-15-2022, 01:47 PM
trudukeblu1973 Re: Try this ! 04-19-2022, 04:56 PM
Marc L Maybe … 04-19-2022, 07:13 PM
trudukeblu1973 Re: Create a new Worksheet... 04-20-2022, 12:06 PM
Marc L Re: Create a new Worksheet... 04-20-2022, 01:15 PM
  1. #1
    Registered User
    Join Date
    09-14-2021
    Location
    Newport News, VA
    MS-Off Ver
    Office 365
    Posts
    15

    Create a new Worksheet for each subtotal from master worksheet

    Hello,

    I am looking for VBA code to look at my active worksheet, which has been subtotaled, and create a new worksheet within the same workbook for each group of subtotals, and ideally name each new sheet the name of the subtotal name.

    For example, attached is my subtotaled information. I would like a new worksheet for ABC, DEF and GHI, named those, and then pull in row 1 (headers) for each, and then all the corresponding data that goes with each vendor. The number of different subtotals will vary but right now there can be as many as 20 with about 7000 lines of data.
    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. Need to create a Master worksheet
    By CLow9 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-21-2015, 01:36 PM
  2. [SOLVED] Macro to Copy Master Worksheet create and paste in new auto named worksheet
    By TheRealLethality in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2014, 12:46 AM
  3. How can i create a master worksheet
    By Deanobey in forum Excel General
    Replies: 1
    Last Post: 05-15-2009, 09:48 AM
  4. [SOLVED] create a master worksheet template
    By Derek in forum Excel General
    Replies: 0
    Last Post: 01-10-2006, 11:45 AM
  5. [SOLVED] create master worksheet
    By sarah daly in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-22-2005, 01:50 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