+ Reply to Thread
Results 1 to 2 of 2

Copy rows from multiple workbooks and paste into summary workbook

  1. #1
    Registered User
    Join Date
    09-15-2017
    Location
    Toronto
    MS-Off Ver
    2010
    Posts
    12

    Lightbulb Copy rows from multiple workbooks and paste into summary workbook

    Hello,

    Hoping someone can help me with a code to do this.

    I'm looking to create a summary Workbook with a button that once clicked will do the following:
    - Copy rows 10, 11, 12 from first sheet on 40+ different workbooks (they can be opened, but would prefer to keep closed in a folder)
    -- The sheet I want to copy the data from in each workbook will have the same name (let's say "BOOK")
    - Paste as "Paste Formulas & Number Formatting" one after the other starting on next blank row in the summary workbook sheet where the button is located


    Thanks in advance!!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,483

    Re: Copy rows from multiple workbooks and paste into summary workbook

    I have a pretty good example video that can show you how to do this.
    https://www.youtube.com/watch?v=6XsvI9i2z7s

    The code is here,
    http://www.xlorate.com/vba-examples....rough%20Folder

+ 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. Copy Paste Values from multiple workbooks to multiple sheets in one workbook
    By tatendamark in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-12-2017, 09:54 AM
  2. vba to copy from multiple workbooks to a summary sheet in another workbook.
    By lisadykstra in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-22-2014, 03:36 PM
  3. Copy multiple workbooks/worksheets into one summary workbook
    By CC2013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-23-2013, 05:58 AM
  4. [SOLVED] Open Multiple Workbooks, Record names, Copy paste to Active Workbook, Close the Workbooks
    By vba_madness in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2013, 06:09 AM
  5. [SOLVED] Macro To Copy Specific cells From Multiple Workbooks to New Summary Workbook
    By Mooseman60 in forum Excel Programming / VBA / Macros
    Replies: 36
    Last Post: 06-19-2012, 07:38 AM
  6. copy & paste data from multiple workbooks to new workbook in a folder
    By Ignesh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-01-2012, 03:11 AM
  7. copy paste from multiple workbooks to master workbook
    By ravinder_tigh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2009, 02:29 AM

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