Closed Thread
Results 1 to 2 of 2

Macro button to split data to multiple work book

  1. #1
    Forum Contributor
    Join Date
    06-12-2013
    Location
    india
    MS-Off Ver
    Office 365
    Posts
    163

    Macro button to split data to multiple work book

    Please delete my old thread (link given below) and need help on the below request.
    https://www.excelforum.com/excel-pro...ml#post5195861.


    I do have an Macro file with the code where when I paste my data in to Raw data sheet and click on the button it will ask to select the headers on the file and again I need to enter the column header where I need to split the data based on that column and data is getting segregated on the same file.

    So I need the data based on below given requirements. Kindly help me on this.

    When I click on the macro button, pop up should open to select the report from my local drive(the report will be in .xls or .xlsx or .csv format)
    - Once I selected the report it should ask for the column header name to input.
    - Once I input the column header name, the data needs to split in to multiple work books based on the unique cell value on the selected column.
    - before saving the file the comma "," should be replaced with semicolon";" in any of the cell on the given workbook.
    - the splitted work book should be named as "cell value - macro work book name". and file should be save in .csv format


    -----for example: macro work book name is "Book1" and I do have the cell value like "ABC", "BCA", "DAB". so when I split the data to multiple workbooks it should name as below.

    ABC - Book1
    BCA - Book1
    DAB - Book1

    Please let me know if you need any further details
    Attached Files Attached Files
    Last edited by Giri.hb; 09-20-2019 at 01:20 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Macro button to split data to multiple work book

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-pro...ml#post5195861

    If you do not get answers within a reasonable time lapse, you can always " bump" your thread.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro button to split data to multiple work book
    By Giri.hb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-20-2019, 03:05 AM
  2. [SOLVED] Can This Macro for a command button be made to work in any book
    By TBM in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-02-2018, 11:11 AM
  3. macro for split work book and save it in to new folder
    By ikshanu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-10-2015, 01:19 PM
  4. How to add multiple subs / criteria to one work book macro vba
    By no1freeman in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 03-07-2015, 03:51 AM
  5. Replies: 3
    Last Post: 02-24-2014, 02:39 PM
  6. Recording a Macro to be used on multiple spreadshets within work book
    By sds33 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-18-2013, 04:49 AM
  7. Split One Work book into several based on content
    By Rich in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-21-2006, 01:30 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