+ Reply to Thread
Results 1 to 16 of 16

VBA to data Split from column values as new workbook save into folder with dashboard sheet

  1. 01-06-2014, 01:15 PM #1
    breadwinner
    breadwinner is offline
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    VBA to data Split from column values as new workbook save into folder with dashboard sheet

    Dear experts

    i need help on my project with vba code...

    I have master file in sheet Opencall,column A:A contains some multiple partner name, I want split every partner name as newworkbook save it in same partner name with dashboard sheet with formula into particular path

    file save to Path is C:\Users\lara\Desktop\splitedfile


    MASTER.XLS contains two sheet OPENCALL and Dashboard..if split the column values from Opencall sheet column A:A


    result Aegis Infoware Pvt. Ltd xls along with sheet(Opencall,Dashboard with fomula)
    result Aim Enterprises.xls along with sheet (Opencall,Dashboard with formula)


    Thanks
    find the attachment
    Aegis and Aim Enterprises file is my expected result
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-06-2014, 04:30 PM #2
    venkatpvc
    venkatpvc is offline
    Forum Contributor
    Join Date
    03-28-2013
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    226

    Re: VBA to data Split from column values as new workbook save into folder with dashboard s

    try the attachment,
    May you have to shrink the some company names because a sheet name cannot have more than 31 words.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by venkatpvc; 01-06-2014 at 05:31 PM. Reason: as per AB33 post
    Give Feedback and Click(*)
    Reply With QuoteRegister To Reply
  3. 01-06-2014, 05:23 PM #3
    natefarm
    natefarm is offline
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: VBA to data Split from column values as new workbook save into folder with dashboard s

    Here's another route. I had already developed it when I came back and saw that venkatpvc had responded, so take your pick.

    I saw that your Dashboard was really just a pivot table with a little nicer formatting, so I wrote code that would produce pivot tables for each partner in a separate workbook.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 01-06-2014, 05:25 PM #4
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA to data Split from column values as new workbook save into folder with dashboard s

    May you have to shrink the some company names because a sheet name cannot have more than 31 words.
    Reply With QuoteRegister To Reply
  5. 01-06-2014, 05:32 PM #5
    venkatpvc
    venkatpvc is offline
    Forum Contributor
    Join Date
    03-28-2013
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    226

    Re: VBA to data Split from column values as new workbook save into folder with dashboard s

    thank you AB33 for correcting me there, I am still learning.
    Reply With QuoteRegister To Reply
  6. 01-06-2014, 05:32 PM #6
    natefarm
    natefarm is offline
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: VBA to data Split from column values as new workbook save into folder with dashboard s

    If file name length is a problem: 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 01-06-2014, 09:28 PM #7
    breadwinner
    breadwinner is offline
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: VBA to data Split from column values as new workbook save into folder with dashboard s

    No Probs Save split file sheet as "Opencall" Not required save as Partner name ....
    Reply With QuoteRegister To Reply
  8. 01-07-2014, 05:35 AM #8
    breadwinner
    breadwinner is offline
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: VBA to data Split from column values as new workbook save into folder with dashboard s

    Dear experts thanks for being spend time for my post

    can u close this with two step
    first is split sheet name as "Opencall",
    Second is Apply paste special values to range Range("a1:i21") after split the file...

    find the attachment is expected result like this all files need to split and save...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 01-07-2014, 11:13 AM #9
    venkatpvc
    venkatpvc is offline
    Forum Contributor
    Join Date
    03-28-2013
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    226

    Re: VBA to data Split from column values as new workbook save into folder with dashboard s

    Try this attachment.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 01-07-2014, 12:53 PM #10
    johnodys
    johnodys is offline
    Forum Contributor
    Join Date
    07-23-2013
    Location
    bangalore
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    143

    Re: VBA to data Split from column values as new workbook save into folder with dashboard s

    Venkat Sir works perfectly amazing You make me relax at my desk by done this..solved But one more thing last if Partnername is contain Dot(.) Data not split by your code e.g Aegis Infoware Pvt. Ltd,M.J.Enterprises,Ultra ITSs Pvt Ltd. those values files not created rest of thing are correct
    Last edited by johnodys; 01-07-2014 at 12:58 PM.
    Reply With QuoteRegister To Reply
  11. 01-07-2014, 01:36 PM #11
    venkatpvc
    venkatpvc is offline
    Forum Contributor
    Join Date
    03-28-2013
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    226

    Re: VBA to data Split from column values as new workbook save into folder with dashboard s

    try this attachment.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  12. 01-07-2014, 09:31 PM #12
    breadwinner
    breadwinner is offline
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: VBA to data Split from column values as new workbook save into folder with dashboard s

    Venkat Sir File Get Splited But There is no data in the sheet...Please check the code
    Reply With QuoteRegister To Reply
  13. 01-07-2014, 10:05 PM #13
    venkatpvc
    venkatpvc is offline
    Forum Contributor
    Join Date
    03-28-2013
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    226

    Re: VBA to data Split from column values as new workbook save into folder with dashboard s

    try attachment.
    Attached Files Attached Files
    Last edited by venkatpvc; 01-07-2014 at 10:13 PM.
    Reply With QuoteRegister To Reply
  14. 01-07-2014, 10:20 PM #14
    breadwinner
    breadwinner is offline
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: VBA to data Split from column values as new workbook save into folder with dashboard s

    Its works Perfectly Venkat Sir Thanks alot !!! Should I keep that sheet (Filename) ?
    Reply With QuoteRegister To Reply
  15. 01-07-2014, 10:23 PM #15
    venkatpvc
    venkatpvc is offline
    Forum Contributor
    Join Date
    03-28-2013
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    226

    Re: VBA to data Split from column values as new workbook save into folder with dashboard s

    updated attachment use this.

    Edit: If this attachment solve your problem please mark this thread as SOLVED.
    pleae add my reputation by clicking star under my post.
    Attached Files Attached Files
    Last edited by venkatpvc; 01-07-2014 at 10:33 PM.
    Reply With QuoteRegister To Reply
  16. 01-08-2014, 02:03 AM #16
    breadwinner
    breadwinner is offline
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: VBA to data Split from column values as new workbook save into folder with dashboard s

    Thanks Alot Venkat sir again Works works Keep helping Me Thanks for support???
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. need vba code to split 3 column data as name of workbook into target folder
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2013, 05:29 AM
  2. Split Data Into Multiple Workbook Based On Column value with exisitng sheet
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2013, 09:23 AM
  3. Split Data Unique Value From 2 Sheet of A column and Move to 2 Sheet with Splited Values
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2013, 04:21 AM
  4. Split raw data into several worksheet and save as new workbook filter by column name
    By dare2join in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2012, 11:15 AM
  5. [SOLVED] Save Active Sheet As New Workbook in same folder of the original workbook
    By Taislin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-19-2012, 07:03 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1