+ Reply to Thread
Results 1 to 2 of 2

Combine folder sheets to one master sheet

  1. #1
    Registered User
    Join Date
    04-04-2014
    Location
    India,Pune
    MS-Off Ver
    Excel 2013
    Posts
    99

    Combine folder sheets to one master sheet

    Hi,

    I have extracted excel sheets to one folder now i want to macro which can copy all data from sheet with same format and paste one by one in master sheet just below after 1sheet data over for ex. 1st sheet data end on column "A20" then second sheet data paste on just below on that i.e. "A21" and so on. After copy from data from sheets its will be closed automatically and 2nd sheet onwards data copy from 2nd row because every sheet had same header which i don't want.

    Hope anyone understand my above question.

    Thanks in advance.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Combine folder sheets to one master sheet

    Try this add-in by Ron de Bruin

+ 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] combine multi workbooks into one master workbook but I want to combine only sheet 3
    By Goodstart14 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-31-2013, 12:22 AM
  2. Marcto to copy sheets from one workbook to a master sheet, for all files in folder
    By crombieguy91 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-14-2013, 11:12 AM
  3. [SOLVED] Macro to combine specific sheets into master sheet
    By JakubPrchal in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-16-2012, 08:34 AM
  4. Get txt files from a folder to master file in different sheets
    By aravindhan_31 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2009, 05:29 AM
  5. Anyway to combine multiple sheets into master?
    By rbzurich in forum Excel General
    Replies: 1
    Last Post: 06-12-2007, 11:13 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