+ Reply to Thread
Results 1 to 5 of 5

Merging data from different files

  1. #1
    Registered User
    Join Date
    12-27-2012
    Location
    hk
    MS-Off Ver
    Excel 2010
    Posts
    8

    Merging data from different files

    Dear All
    I have a few excel files with the same format, different colleagues in my team will key in their own data at their own file, can I merge data from these files into one single sheet without open>copy>paste?
    Thank you.
    Wan

  2. #2
    Forum Contributor Jack7774's Avatar
    Join Date
    08-31-2012
    Location
    Georgia, US
    MS-Off Ver
    Excel 2010
    Posts
    576

    Re: Merging data from different files

    You could try this or you could do it manually or you could use a macro but RDB merge is the fastest and easiest option usually.

    http://www.rondebruin.nl/win/addins/rdbmerge.htm
    Thank those who have helped you by clicking the Star * below their name and please mark your post [SOLVED] if it has been answered satisfactorily.

  3. #3
    Forum Contributor Jack7774's Avatar
    Join Date
    08-31-2012
    Location
    Georgia, US
    MS-Off Ver
    Excel 2010
    Posts
    576

    Re: Merging data from different files

    Did this bring you a solution you had in mind? If so could you mark this as solved and give rep to those who've helped you.

  4. #4
    Registered User
    Join Date
    12-27-2012
    Location
    hk
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Merging data from different files

    Hi JACK
    Sorry for the late reply.
    Thank you for your suggestion and it really work.
    Wan

  5. #5
    Forum Contributor Jack7774's Avatar
    Join Date
    08-31-2012
    Location
    Georgia, US
    MS-Off Ver
    Excel 2010
    Posts
    576

    Re: Merging data from different files

    sweet. anytime.

+ 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] Merging Data from multiple excel files into 1 single worksheet
    By Nerpilis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2014, 12:13 PM
  2. Merging data in two excel files
    By The Chief in forum Excel General
    Replies: 2
    Last Post: 11-13-2012, 10:19 AM
  3. Need Help Merging Two Excel Files with different data
    By kevinnathenbowie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-27-2012, 05:04 PM
  4. Replies: 9
    Last Post: 04-16-2012, 10:20 AM
  5. Merging two files together based on col common to both files
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-05-2011, 01:06 PM
  6. Merging data files - solved
    By andrewlong in forum Excel General
    Replies: 4
    Last Post: 12-10-2010, 09:59 AM
  7. Merging files, layout for data input
    By Sprucemoose in forum Excel General
    Replies: 6
    Last Post: 02-28-2010, 05:15 PM

Tags for this Thread

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