Results 1 to 3 of 3

Split the excel based on headings list

Threaded View

  1. 07-19-2018, 09:38 AM #1
    gopalpithani
    gopalpithani is offline
    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
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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. 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. [SOLVED] How do I split a list by every other one in excel?
    By jont in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1