+ Reply to Thread
Results 1 to 4 of 4

Macro does not appear to be matching data and adding comments on all columns

  1. #1
    Registered User
    Join Date
    08-02-2005
    Posts
    39

    Macro does not appear to be matching data and adding comments on all columns

    Hi

    I was given this code by an old work colleague and he has now left and I not got a clue if correct as when I try and run it its not highlighting right across all the lrow

    What is supposed to happen is the code go thru the NEW sheet and searches for the data on the OLD Sheet.
    If the data is found, it highlights both rows Green and add Match Found on both sheets
    In the data is not found it will highlight the row on the NEW sheet Blue and add Not Found.

    What I also need to do if poss is the same but the other way round too. If the data in the OLD sheet but not NEW sheet I need it to highlight the row on the NEW sheet Blue and add Not Found too.

    What I need it to do is go across columns b-e on both sheets. Can anyone confirm for me or be able to amend please.


    Please Login or Register  to view this content.
    Last edited by tweacle; 10-12-2019 at 04:18 PM.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    8,367

    Re: Macro does not appear to be matching data and adding comments on all columns

    Seems to me that before you run the code if you highlight all rows on both sheets as Blue and Not Found, and then if the code highlights found rows green on both sheet, then whatever is not green is still blue and not found.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in your menu for the forum editor will apply the CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    08-02-2005
    Posts
    39
    Quote Originally Posted by AlphaFrog View Post
    Seems to me that before you run the code if you highlight all rows on both sheets as Blue and Not Found, and then if the code highlights found rows green on both sheet, then whatever is not green is still blue and not found.
    Aaahhhh right I was not told that will give it a try and let you know.

  4. #4
    Registered User
    Join Date
    08-02-2005
    Posts
    39

    Re: Macro does not appear to be matching data and adding comments on all columns

    Hi it works but it seems too complex for me and wondered if there was an easier way via macro or formula I can do what im trying to achieve.


    What im trying to do is look in columns B-E against rows J-M for missing items and if missing they come up with the word missing in column F.

    Then I need to look for duplicated entries in columns J-M If I have duplicates iit comes up with duplicate in column N.

    After that I finally need to compare rows J-M against columns B-F and if missing from columns B-F I need the word missing to come up in column O

    When I mean B-E etc I want all the data in the row of the columns to be an exact match across them all and not just 1 column in the row.

    Could this be done?

+ 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