+ Reply to Thread
Results 1 to 5 of 5

Copying data from a large number of workbooks

  1. #1
    Forum Contributor
    Join Date
    02-08-2005
    MS-Off Ver
    Microsoft 365
    Posts
    676

    Copying data from a large number of workbooks

    Hi,

    I have a few dozen workbooks from each of which Id like to copy the data in columns A to H of Sheet1 and paste it into a single worksheet. So, for example, the data from the first workbook would go into A1:H50 of the destination sheet, from the second workbook to A51:H100 etc.

    Obviously I could copy the data in each of the worksheets and paste it all into a single worksheet, but I was hoping that someone could please suggest an easier (and less error-prone) solution?

    Thanks very much!

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Copying data from a large number of workbooks

    Are you familiar with VBA? You can easily setup a macro to do all of this for you.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Forum Contributor
    Join Date
    02-08-2005
    MS-Off Ver
    Microsoft 365
    Posts
    676

    Re: Copying data from a large number of workbooks

    I'm afraid not.

    Can this be easily done without a macro?

    Thanks

  4. #4
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Copying data from a large number of workbooks

    Yeah, copy and paste.

  5. #5
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Copying data from a large number of workbooks

    AllFilesOpen&Import.xlsb

    See the attached.

    I have commented the code pretty well so you can see what I am doing, why I am doing it and what to do with it.

    Let me know if you have any questions.
    Last edited by mikeTRON; 08-12-2014 at 01:58 PM.

  6. #6
    Forum Contributor
    Join Date
    02-08-2005
    MS-Off Ver
    Microsoft 365
    Posts
    676

    Re: Copying data from a large number of workbooks

    Thanks 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. Manage a large amount of workbooks with CSV imported data
    By Chris_SS in forum Access Tables & Databases
    Replies: 4
    Last Post: 05-22-2014, 07:27 PM
  2. Replies: 1
    Last Post: 10-10-2012, 10:23 AM
  3. Copy data from one large worksheet to multiple workbooks
    By richzip in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2008, 02:05 PM
  4. Select same range from large number of workbooks
    By BillC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-18-2005, 05:06 PM
  5. [SOLVED] Extracting same column from large number of workbooks
    By BillC in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-18-2005, 05:06 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