+ Reply to Thread
Results 1 to 1 of 1

Creating Workbook and sheets from spreadsheet

  1. #1
    Registered User
    Join Date
    05-29-2021
    Location
    Lebanon Junction, Ky.
    MS-Off Ver
    2016
    Posts
    21

    Creating Workbook and sheets from spreadsheet

    Is it possible to take a spreadsheet and create a new workbook and sheets using a macro? I'm trying to create a new workbook based on "Originating Department" in the base spreadsheet.
    The new workbook would have a tab for the "Originating Department" for an overall view and sheets created for the "CC#" that corresponds to the originating department.
    Attached Files Attached Files

+ 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. Creating a Last man standing spreadsheet (Workbook)
    By Patcheen in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 08-01-2020, 12:14 AM
  2. Creating a new workbook, copying sheets & saving workbook - Subscript error
    By amphinomos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-30-2014, 09:04 AM
  3. Replies: 0
    Last Post: 04-11-2013, 10:44 AM
  4. Creating a PDF of two Sheets from a workbook
    By rguliuzza in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-07-2012, 01:10 PM
  5. Replies: 10
    Last Post: 09-27-2011, 03:40 PM
  6. Help with creating and populating sheets from a register/spreadsheet
    By newguyoz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-30-2011, 09:58 PM
  7. Creating a list of Sheets within a Workbook
    By M.Blythe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-27-2010, 04:14 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