+ Reply to Thread
Results 1 to 14 of 14

Export Multiple wbk from main wbk

  1. #1
    Forum Contributor
    Join Date
    08-04-2016
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    225

    Export Multiple wbk from main wbk

    Dear All

    There is two wbk in attachments!
    I required to export the wbk from wbk named sample and other is exported wbk!
    There is 4 columns data in sample file.
    Column A is data numbers, Column B id iD, column C is count of each wbk and column D id info!
    Wbk will be exported based the count of column C, means first wbk will export 500 data, 2nd with 2500, 3rd with 100 and 4th with 150 and soo on (if more exist in said columns!) Total 4 wbk will be exported!
    Removed all dashes, spaces leading trailing and wbk name will be =+B2&"-"&C2 and will save where the actual wbk exist!
    All wbk will be exported with leading 0 to new wbk!
    I made sample for only frist 500 data numbers! wbk will be exported in .CSV format!
    thx
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Export Multiple wbk from main wbk

    Re: your PM

    See if this is how you wanted.

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    08-04-2016
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    225

    Re: Export Multiple wbk from main wbk

    almost like this but some changes!
    1,count will be observe of column C of sample file , first wbk will be exported of 500 numbers as per c2 value and that 500 numbers will come up from column A of sample wbk i highlighted with yellow and also others.
    2,in exported workbook in column B ,no dashed and spaces required. only will numbers like 0415656560, 0424747472, 0424747473, 0424747474 if Numbers not have leading 0 than code will make ,if already has it will be exported with leading 0,
    3, wbk name will be sales id B2 and count numbers c2, like formula =CONCATENATE(B2,"-",C2) it will be now for first wbk name 4141p-500, 2nd 5289-2500!

    all others thinks are good. please help

    Regards
    Adeel
    Attached Files Attached Files
    Last edited by adeel1; 09-06-2019 at 09:04 AM.

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Export Multiple wbk from main wbk

    The attachment in you last post is invalid.
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    08-04-2016
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    225

    Re: Export Multiple wbk from main wbk

    in exported wbk numbers are fix only one number is appearing in all files with same sale id, numbers and sales id isn't fix sir!

    first 500 numbers will have 4141p
    next 2500 will have 5289
    next 100 will have 0458
    next 150 will have C8965

    and count of all wbk isn't as per column C!
    Attached Files Attached Files
    Last edited by adeel1; 09-06-2019 at 09:21 AM.

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Export Multiple wbk from main wbk

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    08-04-2016
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    225

    Re: Export Multiple wbk from main wbk

    its good now, this is still missing !
    first 500 numbers will have 4141p
    next 2500 will have 5289
    next 100 will have 0458
    next 150 will have C8965

    and count of all wbk isn't as per column C!

  8. #8
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Export Multiple wbk from main wbk

    This is the last.
    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    08-04-2016
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    225

    Re: Export Multiple wbk from main wbk

    thanks you sir, one issue persist!
    each time numbers is coping from A2 of all exported wbk , if first 500 numbers exported than next will start from after 500 for next wbk, similarly for others
    and i know leading 0 will not appear in wbk but when you will open in notebook it should appear there which means it has leading 0 in wbk.
    all other things are working perfectly,please just makes these last amends please
    Attached Images Attached Images

  10. #10
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Export Multiple wbk from main wbk

    Please Login or Register  to view this content.

  11. #11
    Forum Contributor
    Join Date
    08-04-2016
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    225

    Re: Export Multiple wbk from main wbk

    Hi sir Jindon
    This is outclass now, perfect, perfect, perfect!
    you are amazing sir, its create all wkbs within no time, super fast ,perfectly amazing
    thnx you so much!

    Adeel

  12. #12
    Forum Contributor
    Join Date
    08-04-2016
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    225

    Re: Export Multiple wbk from main wbk

    My apology sir it was not part of opening post I missed it just came in front while working! It is my mistake.
    If sales id are similar and count is also similar than it should create all wbk,
    Code is working good I do not need any change in code, just change name of wbk and export wbk if sales id and count is same! Like 4141p-500-1,
    4141p-500-2, 4141p-500-3 and C8965-500-1, C8965-500-2
    Attached Files Attached Files

  13. #13
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Export Multiple wbk from main wbk

    Please Login or Register  to view this content.

  14. #14
    Forum Contributor
    Join Date
    08-04-2016
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    225

    Re: Export Multiple wbk from main wbk

    thnx you so much sir for brilliant help, you are awesome!

    Adeel

+ 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] How to export code from a text editor in the main workbook to a text editor for many files
    By Feisty2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-17-2018, 01:36 PM
  2. Export data from the main sheet to many open files
    By Joky in forum Excel Programming / VBA / Macros
    Replies: 42
    Last Post: 02-09-2018, 11:57 PM
  3. Autopopulating multiple sheets from one main sheet
    By HayleyN in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-27-2017, 01:27 PM
  4. [SOLVED] Merge multiple sheets to main one
    By Gazou in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-22-2015, 12:47 PM
  5. Inputting data from multiple instances from multiple users into a main Excel Workbook
    By smooth_beaker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2013, 12:18 AM
  6. vlookup on multiple workbooks into 1 main sheet
    By Fub21 in forum Excel General
    Replies: 16
    Last Post: 02-14-2011, 09:11 PM
  7. Viewing multiple worksheets on one main worksheet
    By Brockwood in forum Excel General
    Replies: 3
    Last Post: 05-15-2009, 12:00 AM

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