+ Reply to Thread
Results 1 to 4 of 4

merge different excel sheets

Hybrid View

  1. 12-20-2016, 10:45 AM #1
    fahadmohsin
    fahadmohsin is offline
    Registered User
    Join Date
    11-18-2016
    Location
    Islamabad, Pakistan
    MS-Off Ver
    2010
    Posts
    42

    merge different excel sheets

    Hi,

    I have about 150 excel sheets and I want them in one excel file in different tabs, is there a way for this or do I have to do this manually.
    Reply With QuoteRegister To Reply
  2. 12-20-2016, 10:55 AM #2
    mikeTRON
    mikeTRON is offline
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: merge different excel sheets

    Assuming you mean you have 150 different excel workbooks and you want to move them all to one workbook, that is possible with VBA.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
    Reply With QuoteRegister To Reply
  3. 12-20-2016, 10:57 AM #3
    fahadmohsin
    fahadmohsin is offline
    Registered User
    Join Date
    11-18-2016
    Location
    Islamabad, Pakistan
    MS-Off Ver
    2010
    Posts
    42

    Re: merge different excel sheets

    Yes these are all different workbooks, what exactly is VBA ???
    Reply With QuoteRegister To Reply
  4. 12-20-2016, 03:26 PM #4
    mikeTRON
    mikeTRON is offline
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: merge different excel sheets

    http://bfy.tw/5NiG
    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. [SOLVED] Help With Compare Two Excel Sheets And Merge
    By gaspower in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-21-2015, 09:03 AM
  2. [SOLVED] How to merge 2 different Excel Sheets into one
    By Vanessal in forum Excel General
    Replies: 7
    Last Post: 02-23-2014, 05:20 PM
  3. [SOLVED] merge calenders to excel sheets.
    By leoruphen in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-27-2014, 03:50 AM
  4. Join (Merge) Sheets Excel 2007
    By Cruel in forum Excel General
    Replies: 5
    Last Post: 04-18-2013, 08:04 AM
  5. [SOLVED] Macro to Compare/Merge 2 Excel Sheets
    By Anthony123 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-30-2013, 10:16 AM
  6. Merge two excel sheets
    By dhaval_kpatel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2012, 10:57 PM
  7. How can I merge and purge two excel work sheets?
    By Analia in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 11-02-2005, 06:20 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1