1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multiple workbook to Master workbook in a folder

Discussion in 'VBA Macros' started by venugosr, Mar 19, 2017.

  1. venugosr

    venugosr New Member

    Hi Team,

    Could someone please help to copy multiple workbook from a folder to single workbook.

    For example I have 3 workbook and it has 3 sheets (Sheet1, sheet2 and sheet3)
    I need to copy the values from all the workbook and paste it in Masterwork book.
    Please find the below as an example.

    Book1, Sheet1:
    Book1, Sheet2:
    Book1, Sheet3:
    Likewise i have the details in the other work book.
    Book2, Sheet1:
    Book2, Sheet2:
    Book2, Sheet3:
    Now my requirement is, in the Master workbook I need the consolidate.
    Master Book, Sheet1
    Master Book, Sheet2:
    Master Book, Sheet3:

    Few sheets has data and few sheets are empty.

    Please help me guys!! Thanks a lot in advance.
  2. Marc L

    Marc L Excel Ninja

  3. venugosr

    venugosr New Member

    Hi Marc,

    Thanks, but how could copy the Sheet2 from the source workbook?

    Please advise.
  4. Marc L

    Marc L Excel Ninja

    Just follow tutorials, VBA inner help, use Macro recorder, …

    As we do not want to waste time if you already had an answer
    on another forum 'cause we can't check without any link
    as yet explained in last link of my previous post !
  5. venugosr

    venugosr New Member

    Hi Marc,
    I don't have the answer yet. Hope you understand else leave it.

Share This Page