+ Reply to Thread
Results 1 to 3 of 3

combine multiple excels into single excel as different sheets

  1. 03-06-2015, 02:25 AM #1
    saidineshbabu is offline
    Registered User
    Join Date
    08-27-2012
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    48

    combine multiple excels into single excel as different sheets

    I have 4 excel sheets in a folder.

    Apple
    Mango
    Orange
    Banana
    Final
    I wanted all the excel contents to be added as sheets in “Final”excel in the same path. The sheet names should be same as file names (Apple, Mango, Orange, Banana). How can I do this through Macro?

    Any help will be highly appreciated.

    Thanks in advance.
    Reply With QuoteRegister To Reply
  2. 03-06-2015, 03:53 AM #2
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,891

    Re: combine multiple excels into single excel as different sheets

    have a look here: https://www.youtube.com/watch?v=MsbdMiruX68 or http://www.rondebruin.nl/win/s3/win008.htm or https://support.office.com/en-ie/art...e-e55b20cda2ef
    Best Regards,

    Kaper
    Reply With QuoteRegister To Reply
  3. 03-06-2015, 05:19 AM #3
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: combine multiple excels into single excel as different sheets

    you can try the code in following link.
    Merging a particular Worksheet from Multiple Workbooks into one Worksheet (Skipping Heading Row, Hidden and Blank Rows)
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com
    Excel is not a matter of Experience, its a matter of Application.
    Say Thanks, Click * Add Reputation
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2007 - Combine Multiple Workbooks into one Workbook Multiple Sheets
    By mab in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2014, 02:48 PM
  2. Combine data from different sheets into a single sheet
    By cndesu in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-28-2012, 08:25 PM
  3. Merge multiple excels with multiple sheets in a master excel with multiple sheets
    By marchi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-15-2012, 10:37 AM
  4. Combine Data from Multiple Sheets to Single Sheet
    By mpquin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2009, 06:06 PM
  5. [SOLVED] How do I combine multiple Excel sheets?
    By Tom in forum Excel General
    Replies: 1
    Last Post: 04-15-2006, 06:45 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1