+ Reply to Thread
Results 1 to 22 of 22

Export specific sheet from a file to a specific sheet in many files

  1. #1
    Registered User
    Join Date
    02-24-2018
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    97

    Export specific sheet from a file to a specific sheet in many files

    Hello everyone
    I'm trying to export a specific sheet from an excel file, but without a result
    I want to export Customers sheet to the bank sheet In all the files
    Hope it is clear .. Thanks advanced for help
    Last edited by Feisty2; 05-07-2018 at 04:37 PM.

  2. #2
    Registered User
    Join Date
    02-24-2018
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    97

    Export specific sheet from a file to a specific sheet in many files

    can you help me please?
    Last edited by Feisty2; 04-24-2018 at 03:12 PM.

  3. #3
    Registered User
    Join Date
    02-24-2018
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    97

    Re: Export specific sheet from a file to a specific sheet in many files

    All help is much appreciated.

  4. #4
    Registered User
    Join Date
    02-24-2018
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    97

    Re: Export specific sheet from a file to a specific sheet in many files

    Can someone assist or can give some direction? Thank you

  5. #5
    Registered User
    Join Date
    02-24-2018
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    97

    Re: Export specific sheet from a file to a specific sheet in many files

    Is there some code that I can use to do this for me?

  6. #6
    Forum Contributor
    Join Date
    03-22-2017
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    230

    Re: Export specific sheet from a file to a specific sheet in many files

    you may try this, but you have to

    1. open all the workbooks
    2. put this code at the workbooks have "Customers" tabs and use the code at this workbook.

    It need not care about the workbook name. just above two condition must be meet.
    suggest u close other unrelated workbook to avoid unwanted situation.
    Please Login or Register  to view this content.
    Hope you can learn every time you visit here.

    If you still confuse on how it work, kindly ask or go to
    i) Formula - Formula (Ribbon) > Formula Auditing (Section) > Evaluate Formula > Evaluate; or
    ii) VBA/Code - Click F8 to see how it work step by step.

    It it take care of your question, Please:
    Mark tread as [Solved] [Thread Tools->Mark thread as Solved]
    ;and
    Click *Add Reputation to thank anyone solved your question.

  7. #7
    Registered User
    Join Date
    02-24-2018
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    97

    Re: Export specific sheet from a file to a specific sheet in many files

    Thank you very much Mr. BoredWorker ... You are really a legend
    In fact your solution is very very excellent and big step towards the ultimate aim
    The original file contains code to create many closed files
    How can export the customer sheet with the same formats and equations to bank sheet in all closed files
    Hope it is clear .. I greatly appreciate your effort to help me

  8. #8
    Forum Contributor
    Join Date
    03-22-2017
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    230

    Re: Export specific sheet from a file to a specific sheet in many files

    did you mind to share the code that create lot of closed file?

    it is better to merge both code instead of a vba to open all workbook again.

    if it sensitive to share, please give me the set of the name of closed file or how the file is created.

  9. #9
    Registered User
    Join Date
    02-24-2018
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    97

    Re: Export specific sheet from a file to a specific sheet in many files

    Thank you very much Mr. BoredWorker for your interest in the issue
    I've post a file to explain my request in post 1 .. But without a response
    I have updated the file After two days In an attempt to get a solution
    I have "main workbook" contains a code to create many closed files depending on the column y
    where I would like to put a code that enables me to export Customers file to the bank sheet in all closed files Which will be created
    How can I modify or add code to proceed with this?
    Thanks advanced for help
    Last edited by Feisty2; 05-07-2018 at 04:35 PM.

  10. #10
    Registered User
    Join Date
    02-24-2018
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    97

    Re: Export specific sheet from a file to a specific sheet in many files

    Any help in this topic please?

  11. #11
    Registered User
    Join Date
    02-24-2018
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    97

    Re: Export specific sheet from a file to a specific sheet in many files

    I tried to apply the solution but could not do that
    I welcome any ideas

  12. #12
    Registered User
    Join Date
    02-24-2018
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    97

    Re: Export specific sheet from a file to a specific sheet in many files

    Is it clear or I can not clarify my problem well??
    Hope to get an answer
    Best and kind regards
    Last edited by Feisty2; 05-06-2018 at 08:48 AM.

  13. #13
    Forum Contributor
    Join Date
    03-22-2017
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    230

    Re: Export specific sheet from a file to a specific sheet in many files

    Hi Feisty2,

    It delay due to the weekend.

    i merge the code in post#6 into the original vba sub zz()
    so you can ignore the vba in post#6

    I just include the code into the loop,it should be not affect other, but recommend to have a test on a copy first.

    please ensure the Customer sheets.xlsm is open and don't change the name even the xlsm.

    Please Login or Register  to view this content.

  14. #14
    Registered User
    Join Date
    02-24-2018
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    97

    Re: Export specific sheet from a file to a specific sheet in many files

    Hi BoredWorker,
    Thank you very very much for not forgetting my issue
    Everything is ok except I need to Copying all the formats Customers workbook and pasting into all closed files Which will be created
    I thought it is easy but after many tries I failed and I can't figure it out
    Thanks again for all the great help you offered
    Last edited by Feisty2; 05-01-2018 at 06:52 PM.

  15. #15
    Registered User
    Join Date
    02-24-2018
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    97

    Re: Export specific sheet from a file to a specific sheet in many files

    Any help in this topic please?

  16. #16
    Registered User
    Join Date
    02-24-2018
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    97

    Re: Export specific sheet from a file to a specific sheet in many files

    I'm really at a loss so any help would be appreciated
    Thank you very much
    Last edited by Feisty2; 05-01-2018 at 06:01 PM.

  17. #17
    Forum Contributor
    Join Date
    03-22-2017
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    230

    Re: Export specific sheet from a file to a specific sheet in many files

    change the line to copy command instead of equal.

    should be fit your need.

    Please Login or Register  to view this content.

  18. #18
    Registered User
    Join Date
    02-24-2018
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    97

    Re: Export specific sheet from a file to a specific sheet in many files

    Thank you very much Mr. BoredWorker
    One last point, if possible
    Many files will be created through the original file (about 150 files and probably more )
    so I need to copies the contents of the source worksheet ( Customers workbook ) to all the target worksheets,such as headers/footers, margins, and Print Areas
    Maybe I can not express what I want in this part,But I'm sure you understand what I mean
    Thanks very much for your help
    Last edited by Feisty2; 05-07-2018 at 04:34 PM.

  19. #19
    Forum Contributor
    Join Date
    03-22-2017
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    230

    Re: Export specific sheet from a file to a specific sheet in many files

    correct me if i'm wrong.

    You want to copy printing setting from "workbook customer" to another.

    however, i not strong/familiar with this part,
    what i can do is to copy this worksheet to the target workbook and rename the sheet.
    and change the content afterward, if the content of is not same.

    please let me know the all the worksheet names that needed to have the printing format if this is your need.

  20. #20
    Registered User
    Join Date
    02-24-2018
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    97

    Re: Export specific sheet from a file to a specific sheet in many files

    I am so sorry Mr. BoredWorker for being late in reply
    Yes it is as well as you can do this
    As for the printing format I want the print area to be set in the bank sheet in all files Which will be created
    Thanks a lot for your great support all the time
    Last edited by Feisty2; 05-05-2018 at 11:20 AM.

  21. #21
    Forum Contributor
    Join Date
    03-22-2017
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    230

    Re: Export specific sheet from a file to a specific sheet in many files

    Change the this code
    Please Login or Register  to view this content.
    to:

    you may change the words red font below,
    refer to the source file name and sheet name respectively,

    Please change based on your needs as the name may change from time to time.
    Please Login or Register  to view this content.

  22. #22
    Registered User
    Join Date
    02-24-2018
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    97

    Re: Export specific sheet from a file to a specific sheet in many files

    Thank you very very much Mr. BoredWorker
    Yes this is the perfect code ... I know I have disturbed you..But you are great and patient
    Best Regards from the deep of my heart

+ 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. 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
  2. Need to locate specific sheet, export/save as PDF with a specific filename.
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2018, 09:24 AM
  3. Import data from excel files with specific file name into another excel sheet
    By Nicolina in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-05-2017, 11:42 AM
  4. Replies: 0
    Last Post: 10-12-2015, 10:02 AM
  5. Export only specific sheet to PDF
    By Kandavalli.Kiran in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2015, 10:47 AM
  6. [SOLVED] VBA Script to open a specific File adn activate a specific sheet within that sheet.
    By Kramxel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-05-2013, 01:31 PM
  7. Sheet A in file X to Sheet B in file Y when both files are opened by excel.
    By sunheroj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-09-2012, 09:52 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