+ Reply to Thread
Results 1 to 1 of 1

Create a new workbook based off of column information across worksheets

  1. #1
    Registered User
    Join Date
    02-14-2014
    Location
    Farmington, Utah
    MS-Off Ver
    Excel 2013
    Posts
    43

    Create a new workbook based off of column information across worksheets

    Within my workbook I have 26 worksheets and each sheet has a different amount of columns and rows. What I need to do is to create a new workbook based off of what is in column "C". So each sheet represents a different test. Column "C" on every sheet is the test location. So What I need is a workbook for every location that still has all 26 sheets, and each sheet only represents the location for each workbook. I will post an example of what I need. I hope that makes sense.

    Thanks for the help!!
    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. create worksheets and renamed based of list from other workbook into a template
    By floresp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-18-2015, 03:32 PM
  2. [SOLVED] loop through column, create worksheets based on data within
    By wpryan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-11-2012, 12:50 AM
  3. [SOLVED] Macro to create new worksheets based on column values in a sheet
    By Arjen@bigpond in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-01-2012, 11:18 PM
  4. [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
  5. Create New Worksheets based on one column in a Large Dataset
    By shaolinsnake in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2012, 06:29 PM
  6. Replies: 5
    Last Post: 11-20-2009, 07:33 PM
  7. [SOLVED] CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA
    By control freak in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-20-2006, 01:05 PM

Tags for this Thread

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