+ Reply to Thread
Results 1 to 2 of 2

VBA - Split data into separate workbooks

  1. #1
    Registered User
    Join Date
    10-24-2019
    Location
    Georgia
    MS-Off Ver
    2013
    Posts
    1

    VBA - Split data into separate workbooks

    Hello,

    I have a file where I need to split data in specific columns into separate workbooks so I can give the file to separate individuals. For example, Column A has 3 options, Partner, Sales, Career. So i need to split the data for Partner into a separate workbook. In addition, I need a separate file for Sales and again a separate 3rd file for Career. After that, in column B, I have different categories that I also need to split off into separate workbooks also. For example, If column A says Partner and column B says Call Center then I need a separate file which has all the data for Partner and Call Center. Does anyone know any VBA code that will helpme with this? Right now I am splitting this up manually and it is very, very tedious. Any assistance would be appreciated.

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: VBA - Split data into separate workbooks

    It sounds like an autofilter loop based code could assist your efforts. If you share a sample file, as per the yellow banner above, one of us can assist further. Welcome to the forum!

+ 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 macro to split data into separate workbooks and separate worksheets
    By jfish07 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2019, 10:48 AM
  2. [SOLVED] Creating a macro to split data into separate workbooks
    By jfish07 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2019, 03:42 PM
  3. VBA to Split Worksheets into separate Workbooks by Tab Name
    By krissysteen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-26-2019, 01:56 PM
  4. [SOLVED] VBA to split document into separate workbooks
    By epidemik in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-03-2017, 11:48 AM
  5. [SOLVED] Split pairs of worksheets to separate workbooks
    By vhache in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-17-2016, 05:03 PM
  6. Split multi-tab workbook into separate workbooks
    By ahurst105 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-28-2013, 06:51 PM
  7. [SOLVED] Macro to Split Workbook into separate Workbooks
    By jmurray in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-14-2009, 04:44 AM

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