+ Reply to Thread
Results 1 to 5 of 5

Macro to copy past sheets from different workbooks

  1. #1
    Registered User
    Join Date
    09-12-2016
    Location
    Montreal, Canada
    MS-Off Ver
    2013
    Posts
    23

    Macro to copy past sheets from different workbooks

    Hello All,

    So I have the following workbooks

    1- MainWb
    2 - Wb1 Wb2 Wb3 ... Wb10

    Each workbook 1 through 10 contains a sheet called sheet 1.

    I'd like to copy and paste the content of each sheet 1 in each workbook in one sheet inside Mainwb

    Thanks a lot for your help

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Macro to copy past sheets from different workbooks

    Hi Andre,

    Excel has a newer tool called Power Query that does this job. You will need to install the Power Query Add-In off the Microsoft site and learn a bit to use it. Here are the links:
    https://www.microsoft.com/en-us/down...3-4d455c600b1f

    Here is a YouTube of using PQ to append different workbooks.
    https://www.youtube.com/watch?v=a7E29H5ZUmE
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

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

    Re: Macro to copy past sheets from different workbooks

    Place this macro in a regular module in your Main workbook. Change the file path in the code where indicated to suit your needs. The macro assumes that the folder contains only your 10 source files and nothing else.
    Please Login or Register  to view this content.
    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.

  4. #4
    Registered User
    Join Date
    09-12-2016
    Location
    Montreal, Canada
    MS-Off Ver
    2013
    Posts
    23

    Re: Macro to copy past sheets from different workbooks

    Quote Originally Posted by MarvinP View Post
    Hi Andre,

    Excel has a newer tool called Power Query that does this job. You will need to install the Power Query Add-In off the Microsoft site and learn a bit to use it. Here are the links:
    https://www.microsoft.com/en-us/down...3-4d455c600b1f

    Here is a YouTube of using PQ to append different workbooks.
    https://www.youtube.com/watch?v=a7E29H5ZUmE
    Thank you very much !

  5. #5
    Registered User
    Join Date
    09-12-2016
    Location
    Montreal, Canada
    MS-Off Ver
    2013
    Posts
    23

    Re: Macro to copy past sheets from different workbooks

    Thank you very much !

+ 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] Code to copy and past information from many workbooks
    By phbryan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2015, 03:39 PM
  2. Help with copy and past from multiple sheets
    By klunker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-10-2014, 03:12 PM
  3. [SOLVED] VBA Copy and past value over sheets.
    By Lensmeister in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-04-2013, 11:02 AM
  4. [SOLVED] Copy from single workbook and past to multiple workbooks
    By Alby22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2012, 04:40 PM
  5. Excel Macro Copy&Past data between 2 sheets
    By Nett in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-13-2009, 09:15 AM
  6. Copy and past to different sheets
    By zgclub in forum Excel General
    Replies: 4
    Last Post: 02-09-2006, 08:00 AM
  7. [SOLVED] Copy & Past from multiple sheets to one
    By Prometheus in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 12-04-2005, 08:40 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