Results 1 to 6 of 6
  1. #1
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: finding matching text (Excel 97)

    You will have to be a lot more specific. I am not sure what you want to check, what criterion, etc

    Do you want to check, for example:
    Cell A1 of each sheet and they must be identical on all sheets, then A2, A3, etc then
    Or
    Do you want to make sure that some type of "master list" contains all the NEW entries
    Or
    Something else?
    Could you provide a sheet with couple examples of changes/the same entries and what you want to do with the info.

    Steve

  2. #2
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    finding matching text (Excel 97)

    Please help! I have a worksheet that gets updated every month. How do i tell excel to find all the text that does not match. Example. Headings are "Name" in A1 and "Address" in B1. Every month a new name is added or the address is changed. Example in January the names and address may be John-MT,Mary-ND,Ken-SD. In February it may change to John-MT,Tom-TX,Ken-OK. I want to tell excel to look in sheet 1 then look in sheet 2 and tell me which names and address changed or stayed the same.
    Attached Files Attached Files

  3. #3
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: finding matching text (Excel 97)

    Steve thanks for checking my problem. I have updated the information to make it hopefully more understandable. A list for all new or changed entries is what i'm looking for. In my example John-MT is the only name that stayed the same. What we do now is make a print out of the new and old list. One person reads off the names and address while the other person Marks any changes, then we make a new worksheet and we have to type in all the updates or changes that were made. It takes about 4 days to do this.

  4. #4
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: finding matching text (Excel 97)

    Buckshot,
    I have attached a workbook that shows one way of doing what I think you want. It involves inserting two columns on each sheet. The first column has formulas that add the strings together from col A and col B (Matt and TX becomes MattTX). The cells containing these formulas is assigned a range name (JanList on sheet JAN and FebList on sheet FEB). The second column has a formula that determines if the combined string exists in the named range on the other sheet.
    Then all you have to do is sort the data (on sheet FEB) based on the column that indicates if it is a new name or an existing name and copy the desired rows to the new sheet.
    I am sure there is a way to do this with VBA but the process I laid out could be done manually in less than 10 minutes.

    Chuck
    Attached Files Attached Files
    Chuck Reimer
    I'm from the Government and I'm here to help...

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: finding matching text (Excel 97)

    I am assuming that there is more to your data than just 2 columns which means that we can't give too much example code.

    You could combine ALL the rows together then use an advanced filter to extract out a list of the unique entries

    To get "modifications" I assume that you have some ID or something to demonstrate that they are identical "people" but that have moved. You could add a column to look for "unique" on the code using match, for example, to find NEWER entries. Then you could use an AUTOFILTER to get list just the OLD ones and delete them.

    This could be done manually or with a macro, though we would need a lot more info to help in writing a macro.

    Steve

  6. #6
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: finding matching text (Excel 97)

    Thank you very much. It works great. You saved me alot of time

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •