+ 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
    5,124

    Post

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

  3. #3
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,752

    Re: Split the excel based on headings list

    Please Login or Register  to view this content.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

+ 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