+ Reply to Thread
Results 1 to 15 of 15

Copy data from multiple WorkBook structures to the same sheet on another workbook

  1. #1
    Forum Contributor tax112's Avatar
    Join Date
    02-28-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2016 | 2019
    Posts
    438

    Copy data from multiple WorkBook structures to the same sheet on another workbook

    Hi everybody.
    I need to copy data from many workbooks like the same, for example:
    Example M01.2011, Example M02.2011, ..., Example M12.2016.
    Now I need to Copy D10: L14 into columns(" B:J") of the Sheets ("Master") in another workbook.
    And get the WorkBook name into columns("A:A") of the Sheets ("Master").
    Who knows can help me, thank you.

    111111.jpg
    Last edited by tax112; 09-11-2018 at 06:05 PM.

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,776

    Re: Copy data from multiple WorkBook structures to the same sheet on another workbook

    What is the full path to the folder containing your source files? Are the source files the only files in that folder?
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Forum Contributor tax112's Avatar
    Join Date
    02-28-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2016 | 2019
    Posts
    438

    Re: Copy data from multiple WorkBook structures to the same sheet on another workbook

    All files in the same folder.
    Did you have a solution to help me?

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,776

    Re: Copy data from multiple WorkBook structures to the same sheet on another workbook

    I need to know the full path to the folder containing your source files, for example: "C:\MyFolder". Are the source files the only files in that folder or are there other files as well?

  5. #5
    Forum Contributor tax112's Avatar
    Join Date
    02-28-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2016 | 2019
    Posts
    438

    Re: Copy data from multiple WorkBook structures to the same sheet on another workbook

    All in the same Folder
    The full path is G: \ data \ Input \ Example
    Please help.

  6. #6
    Forum Contributor tax112's Avatar
    Join Date
    02-28-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2016 | 2019
    Posts
    438

    Re: Copy data from multiple WorkBook structures to the same sheet on another workbook

    Can someone help me?

  7. #7
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,776

    Re: Copy data from multiple WorkBook structures to the same sheet on another workbook

    Try this macro in a standard module in your "Master" workbook.
    Please Login or Register  to view this content.

  8. #8
    Forum Contributor tax112's Avatar
    Join Date
    02-28-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2016 | 2019
    Posts
    438

    Re: Copy data from multiple WorkBook structures to the same sheet on another workbook

    Thank you.
    Unfortunately, the data is not copied to Sheets ("Master").
    Please see help me.

  9. #9
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,340

    Re: Copy data from multiple WorkBook structures to the same sheet on another workbook

    the above code has the sheet it is copied from set to be the default name ie "Sheet1".
    What is it called?
    If it is called "Master" then replace "Sheet1" with "Master" in the code.


    Btw no need to end every post with "help me"
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  10. #10
    Forum Contributor tax112's Avatar
    Join Date
    02-28-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2016 | 2019
    Posts
    438

    Re: Copy data from multiple WorkBook structures to the same sheet on another workbook

    I'm know, but not result.
    Thank you.

  11. #11
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,776

    Re: Copy data from multiple WorkBook structures to the same sheet on another workbook

    Is the macro giving you an error message? If it is, what is the error and which line of code is highlighted when you click "Debug"? Make sure that your source worksheets are named "Sheet1" and that your destination sheet is named "Master." I think that it would be easier to help and test possible solutions if I could work with your actual files which includes any macros you are currently using. Perhaps you could upload a copy of your Master file and copies of one or two source files to a free site such as www.box.com or www.dropbox.com. Once you do that, mark each file for 'Sharing' and you will be given a link to each file that you can post here. If the workbooks contain confidential information, you could replace it with generic data.

  12. #12
    Forum Contributor tax112's Avatar
    Join Date
    02-28-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2016 | 2019
    Posts
    438

    Re: Copy data from multiple WorkBook structures to the same sheet on another workbook

    When running your vba code, there are no errors.
    But it does not update the data into Sheets ("Master").

  13. #13
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,776

    Re: Copy data from multiple WorkBook structures to the same sheet on another workbook

    When I tried the macro on some dummy workbooks, it worked properly. Can you upload copies of your file as I described in Post# 11?

  14. #14
    Forum Contributor tax112's Avatar
    Join Date
    02-28-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2016 | 2019
    Posts
    438

    Re: Copy data from multiple WorkBook structures to the same sheet on another workbook

    I know the error of why not update.
    Thank you, I have updated the data.

  15. #15
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,776

    Re: Copy data from multiple WorkBook structures to the same sheet on another workbook

    You are very welcome. Glad it worked out.

+ 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] VBA to Copy data from multiple workbook to a master sheet
    By Lijith in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-13-2015, 10:50 PM
  2. [SOLVED] copy data in one sheet to multiple sheets in same workbook
    By Alan in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-06-2005, 06:05 PM
  3. copy data in one sheet to multiple sheets in same workbook
    By BrianMultiLanguage in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  4. copy data in one sheet to multiple sheets in same workbook
    By BrianMultiLanguage in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. copy data in one sheet to multiple sheets in same workbook
    By BrianMultiLanguage in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  6. copy data in one sheet to multiple sheets in same workbook
    By BrianMultiLanguage in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. [SOLVED] copy data in one sheet to multiple sheets in same workbook
    By BrianMultiLanguage in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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