+ Reply to Thread
Results 1 to 3 of 3

Split the excel based on headings list

  1. #1
    Registered User
    Join Date
    07-19-2018
    Location
    india
    MS-Off Ver
    2016
    Posts
    3

    Split the excel based on headings list

    I hava an excel and it contains some provider name as heading and it's relevant data and again provider name as heading and it's relevant data and so on. i want to split the data of excel in to workbooks such that each file contains name as provider name and its relevent data in each workbook.could anyone help me in achieving this. Thanks in advance. i am attaching the master file and also the sample output file. Please help me in this regards.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Post

    Removed 'cause of duplicate thread …
    Last edited by Marc L; 07-19-2018 at 05:52 PM.

  3. #3
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Split the excel based on headings list

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ 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. [SOLVED] vba split data in respective columns based on unique list sheet
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2017, 02:40 PM
  2. [SOLVED] Split list into multiple sheets based on criteria (For each/next)
    By nymanns in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-10-2017, 04:16 PM
  3. [SOLVED] Split the data to new files based on the date and name it from the list provided
    By Jul Stev in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-09-2014, 04:26 AM
  4. How to select multiple data from a list based on different headings
    By adhide in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-03-2013, 07:28 PM
  5. [SOLVED] Need to split a LONG list into separate sheets based on repeating, incremental nunbers
    By matrix_machine in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-31-2012, 04:37 PM
  6. [SOLVED] how to diag. split a cell for two headings (for row AND column)?
    By beckymspt in forum Excel General
    Replies: 2
    Last Post: 08-02-2006, 05:15 AM
  7. Replies: 4
    Last Post: 03-30-2005, 08:06 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