+ Reply to Thread
Results 1 to 3 of 3

Populate master workbook with data from other workbooks based on criteria lookup

  1. #1
    Registered User
    Join Date
    01-24-2013
    Location
    Tonbridge, UK
    MS-Off Ver
    Excel 2010
    Posts
    3

    Populate master workbook with data from other workbooks based on criteria lookup

    Hi all, this is my first post in the forum and it has to be a request :-) I am trying to collect data from multiple workbooks into a master workbook based on defined criteria ; the first column in the master workbook contains criteria with different values in the other workbooks. the macro should populate the second column with the matching values from the first workbook, then move to the next column and populaate with the next workbook and .....
    Can anyone help with this please?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Populate master workbook with data from other workbooks based on criteria lookup

    Hi nabilbil and welcome to the forum

    I see that this thread is marked as solved, but you have had no replies?

    It is supposed to be marked solved, or did you (or some-one else) mark it solved by mistake?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    01-24-2013
    Location
    Tonbridge, UK
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Populate master workbook with data from other workbooks based on criteria lookup

    Hi FDibbins, I have ni idea why it was markes as solved! I marked it as unsolved, hoping that some one will help with this. Thanks a lot

+ 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