+ Reply to Thread
Results 1 to 2 of 2

Find and Compare against a diff. wkbk list and replace as found in another Wkbk.

  1. #1
    Registered User
    Join Date
    05-25-2007
    Posts
    18

    Find and Compare against a diff. wkbk list and replace as found in another Wkbk.

    I have a list of approx. 3000 titles that will need to be changed. I have this in "Master_List.xls" where Column A and Column B, when used together, are unique. Column C shows the new title. Column D shows the new code.

    I will have approx. 12-15 spreadsheets that will need to be compared against this list. Again, The data type will mimic Columns A|B|C|D, so the columns match in type.

    Is there a way to run a macro or programming that, once I have both workbooks open, it compares Column A and B of the new workbook and compares them against Column A and B of the "Master_list.xls" workbook. If the code is found in the master list, then Copy Columns C and D and replace them into the other workbook in Column E and F ? I would prefer to not overwrite C and D since I want to visually check.

    Thank you.
    Gene

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Hi

    Put the code below in a general module of master_list.xls. It assumes that the current data is in sheet1, headings in row1, and the data starting in A2.

    Please Login or Register  to view this content.
    Have both workbooks open, run the macro. Make sure you include the .xls in the new workbook name when asked.


    HTH

    rylo

+ 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