+ Reply to Thread
Results 1 to 2 of 2

merge sheets in one master sheet

  1. #1
    Forum Contributor
    Join Date
    06-14-2013
    Location
    jk
    MS-Off Ver
    Excel 2007
    Posts
    326

    merge sheets in one master sheet

    Hi Folks,

    I have this file with a nice script (i didn't write myself because i'm n00b).
    But it works: It puts all the excel files from a folder into this sheet.

    The macro is activated by the button in the sheet Combine.
    In my example, the macro already ran and it created 1. xlsx 2, 2. xlsx 2, 3. xlsx 2, 4. xlsx 2.

    Now i'm stuck and i cant find a solution on internet

    What i want is that it consolidates the information from these 4 new created sheets and puts them in the sheet "Consolidate".
    After this, it should remove all sheets except "Combine" and "Consolidate".

    Offcourse, in reality these sheets will be bigger with headers and such things. So it should copy this range. Maybe something like xl end to right.

    Can somebody help me out?

    Regards,
    Crispy
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: merge sheets in one master sheet

    Maybe:

    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] Master sheet to split sheets back to another master sheet
    By FurRelKT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-24-2017, 02:08 PM
  2. Replies: 1
    Last Post: 10-24-2013, 01:05 PM
  3. Merge All Sheets Data Into Master Sheet Based on a condition
    By alfykunable in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2012, 05:24 AM
  4. Add data columns and merge specific data sheets into master sheet
    By sshahils in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-15-2011, 10:50 AM
  5. Overwrite Master sheet when using merge macro
    By Mark Jackson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-08-2005, 11:05 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