+ Reply to Thread
Results 1 to 3 of 3

Combine same sheet from multiple workbooks in the same folder

  1. #1
    Forum Contributor
    Join Date
    11-06-2012
    Posts
    139

    Combine same sheet from multiple workbooks in the same folder

    Hi,

    I have same format workbooks in a folder.

    I would like to combine one specific sheet into one workbook. But i have to do this for multiple folders, so is it possible to do this with an vba?

    I have a code that combines all OPEN workbooks, but i would like to combine all workbook in this path without opening it.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,201

    Re: Combine same sheet from multiple workbooks in the same folder

    One of your fellow countrymen has done the job for all of us http://www.rondebruin.nl/win/addins/rdbmerge.htm

  3. #3
    Forum Contributor
    Join Date
    01-18-2009
    Location
    Montreal
    MS-Off Ver
    MS Office 2016
    Posts
    111

    Re: Combine same sheet from multiple workbooks in the same folder

    Give this a try:
    Please Login or Register  to view this content.

+ 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] Copy Same Sheet to Multiple Workbooks in Folder
    By allie14 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-02-2014, 10:13 AM
  2. [SOLVED] combine 1st sheet from all workbooks in folder
    By onbeillp111 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-18-2014, 05:14 PM
  3. Combine Multiple Workbooks into one box spread sheet
    By Oszie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-02-2013, 07:02 AM
  4. Combine multiple workbooks in a single sheet
    By thomas_people in forum Excel General
    Replies: 2
    Last Post: 09-13-2012, 03:35 PM
  5. combine workbooks stored in the same folder into 1 a summary sheet.
    By lrm75uk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-22-2010, 04:09 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