+ Reply to Thread
Results 1 to 10 of 10

Consolidate Data from Multiple Files (Different File Names) into a Master File

  1. #1
    Registered User
    Join Date
    11-05-2012
    Location
    INdia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Consolidate Data from Multiple Files (Different File Names) into a Master File

    Hi All,

    Being new to the world of macros and VBA, seek guidance here.

    There are multiple workbooks (one for each user saved at the same location/folder) with 5 worksheets within the workbook each. Data is entered by users into their respective workbook under various columns. This data needs to be then updated onto a Masterfile in the manner that:
    1. Data for each respective worksheet gets copied into the same worksheet on the Masterfile.
    2. Data from each of the users' sheets is copied one over other and then sorted chronologically per date of entry.
    3. In case of any 'blank' row of information, the macro over-runs this row to reflect only 'filled' rows of information on the Masterfile.
    4. Information from users' workbooks be updated only when the file has been saved.

    Can we also have a macro-driven 'Refresh' option that helps refresh the data for any reference?

    Let me know should there be requirement for a sample worksheet.

    Thanks.
    Praveen

  2. #2
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Consolidate Data from Multiple Files (Different File Names) into a Master File

    Hi Praveen,

    welcome to the world of Macro's.

    could u plz provide sample worksheet its more helpful to resolve.

    Thanks - Naveed.

  3. #3
    Registered User
    Join Date
    11-05-2012
    Location
    INdia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Consolidate Data from Multiple Files (Different File Names) into a Master File

    Tracker_MASTERFILE.xls.xlsxTracker_User1.xlsHi Naveed,

    Thanks for the prompt response. Please find sample Tracker_User1 that one of the users would updated, and Tracker_Masterfile that needs to pull data from Tracker_User1, Tracker_User2 and more.

    Thanks.

  4. #4
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Consolidate Data from Multiple Files (Different File Names) into a Master File

    Hi Praveen,

    in Tracker user1 have 7 tabs this all 7tabs data need to combine in master file in respective tabs.

    One more thing in that there is no data if possible add some data to that worksheets.

    Thanks - Naveed.

  5. #5
    Registered User
    Join Date
    11-05-2012
    Location
    INdia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Consolidate Data from Multiple Files (Different File Names) into a Master File

    Hi Naveed,

    Please find attached the updated sample file for your reference. The data can be anything so you can enter any data to test-run the macro.
    Thanks.
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    11-11-2012
    Location
    Muscat, Oman
    MS-Off Ver
    Office 365
    Posts
    521

    Re: Consolidate Data from Multiple Files (Different File Names) into a Master File

    Hello Praveen, Are these headers same in all the sheets. Worksheet Process 5 repeats header info15 to info20 in column U to Z.
    Thanks/VKS

  7. #7
    Registered User
    Join Date
    11-05-2012
    Location
    INdia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Consolidate Data from Multiple Files (Different File Names) into a Master File

    Yes. Thanks.

  8. #8
    Registered User
    Join Date
    12-08-2012
    Location
    Baku
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Consolidate Data from Multiple Files (Different File Names) into a Master File

    Im following that topic because ı need such macro so that ı can copy data from files into a masterfile.

  9. #9
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,178

    Re: Consolidate Data from Multiple Files (Different File Names) into a Master File

    Welcome to the Forum etandogan, unfortunately:

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
    HTH
    Regards, Jeff

  10. #10
    Registered User
    Join Date
    12-08-2012
    Location
    Baku
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Consolidate Data from Multiple Files (Different File Names) into a Master File

    Quote Originally Posted by jeffreybrown View Post
    Welcome to the Forum etandogan, unfortunately:

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
    Sorry for that, thanks for your warning.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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