+ Reply to Thread
Results 1 to 15 of 15

Read sheets from different workbooks and copy all content from a certain sheet

  1. #1
    Forum Contributor
    Join Date
    02-18-2013
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2010
    Posts
    145

    Read sheets from different workbooks and copy all content from a certain sheet

    Hello,

    I'm having five workbooks called like this:

    R83_COM1.xlsx
    R83_COM2.xlsx
    R83_COM3.xlsx
    R83_COM4.xlsx
    R83_COM5.xlsx

    Each workbook has three sheets, which have the same names:

    ComSheet1, ComSheet2, ComSheet3

    I've created a workbook called R83_ALL.xlsx with the following sheets:

    COM1, COM2, COM3, COM4 and COM5

    Now I want to copy the "ComSheet2" sheet from the five workbooks to R83_ALL as follows:

    "ComSheet2" from R83_COM1.xlsx to sheet "COM1" in R83_ALL.xlsx
    "ComSheet2" from R83_COM2.xlsx to sheet "COM2" in R83_ALL.xlsx
    "ComSheet2" from R83_COM3.xlsx to sheet "COM3" in R83_ALL.xlsx
    "ComSheet2" from R83_COM4.xlsx to sheet "COM4" in R83_ALL.xlsx
    "ComSheet2" from R83_COM5.xlsx to sheet "COM5" in R83_ALL.xlsx

    Do you know an easy to program this?

    Thank you very much for your help!

  2. #2
    Valued Forum Contributor
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    694

    Re: Read sheets from different workbooks and copy all content from a certain sheet

    Not tested, but possibly...
    Please Login or Register  to view this content.
    Last edited by dangelor; 06-13-2019 at 07:29 AM.

  3. #3
    Forum Contributor
    Join Date
    02-18-2013
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2010
    Posts
    145

    Re: Read sheets from different workbooks and copy all content from a certain sheet

    Hello,

    first of all: thank you very much for taking the time to answer me.

    Unfortunately I receive an error:

    Please Login or Register  to view this content.
    at the line:

    Please Login or Register  to view this content.
    Do you know how to fix this?

  4. #4
    Valued Forum Contributor
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    694

    Re: Read sheets from different workbooks and copy all content from a certain sheet

    Try...
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    02-18-2013
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2010
    Posts
    145

    Re: Read sheets from different workbooks and copy all content from a certain sheet

    Hello,

    I get:

    Please Login or Register  to view this content.
    at

    Please Login or Register  to view this content.

  6. #6
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    2,986

    Re: Read sheets from different workbooks and copy all content from a certain sheet

    Hi !

    You just forgot to update the files path

  7. #7
    Forum Contributor
    Join Date
    02-18-2013
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2010
    Posts
    145

    Re: Read sheets from different workbooks and copy all content from a certain sheet

    Quote Originally Posted by Marc L View Post
    Hi !

    You just forgot to update the files path
    Hello,

    in this line:

    Please Login or Register  to view this content.
    ?

  8. #8
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    2,986

    Arrow


    Of course : where is located the workbook to open ?

  9. #9
    Valued Forum Contributor
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365
    Posts
    1,115

    Re: Read sheets from different workbooks and copy all content from a certain sheet

    i think what he is saying is the following:

    Please Login or Register  to view this content.
    you need the path to the R83_Com# file

  10. #10
    Forum Contributor
    Join Date
    02-18-2013
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2010
    Posts
    145

    Re: Read sheets from different workbooks and copy all content from a certain sheet

    I've entered the path of the files and now we are back to:

    Please Login or Register  to view this content.

  11. #11
    Valued Forum Contributor
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    694

    Re: Read sheets from different workbooks and copy all content from a certain sheet

    Try this...
    Please Login or Register  to view this content.

  12. #12
    Forum Contributor
    Join Date
    02-18-2013
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2010
    Posts
    145

    Re: Read sheets from different workbooks and copy all content from a certain sheet

    Hi,

    now I have:

    Please Login or Register  to view this content.
    at
    Please Login or Register  to view this content.

  13. #13
    Valued Forum Contributor
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    694

    Re: Read sheets from different workbooks and copy all content from a certain sheet

    Try...
    Please Login or Register  to view this content.

  14. #14
    Forum Contributor
    Join Date
    02-18-2013
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2010
    Posts
    145

    Re: Read sheets from different workbooks and copy all content from a certain sheet

    Awesome, works like a charm! Thank you so much for your effort!

  15. #15
    Valued Forum Contributor
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    694

    Re: Read sheets from different workbooks and copy all content from a certain sheet

    We both learned something. Glad to help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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