Results 1 to 9 of 9

Copy/Paste from multiple wbks same folder

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-27-2012
    Location
    New Brunswick, Canada
    MS-Off Ver
    Excel 2016
    Posts
    328

    Copy/Paste from multiple wbks same folder

    I am trying to create a document that will pull Rows 16 & 79 from ALL the other workbooks in the folder my Summary document is in - not looking to make it a specific folder because I have multiple folders with various files (i.e. Blue files, Red files, Yellow files, etc). I'll just drop my Summary file in the folder I need, run it and then grab the info before I drop it into another folder.

    I found a few different solutions but they all seem to want to look in a specific folder. I also would like it to jump rows when it's pasting from each book. I created a template of the Summary file I'd ideally like to put together.

    The books it will pull from will always have the same sheet name, although there won't always be 20 of them - I just picked the largest number would be in any one folder.

    Any help would be appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA C_Paste range from one wbks with multiple ws to multiple wbks and multiple ws
    By jackdaniel99 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2020, 10:02 AM
  2. [SOLVED] copy/paste from multiple files in a folder to single workbook
    By HXIO in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-06-2019, 01:57 PM
  3. [SOLVED] Loop formula to copy and paste worksheet from multiple workbooks within same folder
    By Learning2Code in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2019, 11:08 AM
  4. [SOLVED] Copy range of data from all workbooks in folder and paste to multiple sheets in new book
    By Brontosaurus in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-19-2019, 08:52 AM
  5. open folder has multiple worksheets ,copy specific data from a tab and paste them
    By Khaled Diab in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2014, 05:27 AM
  6. Copy a Template workbook ans paste in a multiple Files in a Folder
    By arvind1979_3 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-24-2013, 09:07 AM
  7. 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

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