+ 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
    Forum Contributor
    Join Date
    08-02-2005
    Location
    LONDON
    MS-Off Ver
    OFFICE365
    Posts
    160

    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
    9,643

    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 the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Contributor
    Join Date
    08-02-2005
    Location
    LONDON
    MS-Off Ver
    OFFICE365
    Posts
    160
    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
    Forum Contributor
    Join Date
    08-02-2005
    Location
    LONDON
    MS-Off Ver
    OFFICE365
    Posts
    160

    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)

Similar Threads

  1. [SOLVED] Macro to compare check-in vs. check-out data
    By skylark332 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-30-2016, 04:12 PM
  2. How to check if excel file is Checked Out in SharePoing Check Out, run code, Check In
    By jrtraylor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-08-2016, 04:36 PM
  3. [SOLVED] Adjust a macro to check for content of a cell and then run a macro on target sheet
    By dreddster in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-17-2013, 04:37 AM
  4. Automatically check one or more check boxes when a parent check box is manually checked
    By Steverizer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-28-2013, 01:56 PM
  5. Macro to force format and check barcode check digit
    By Code Flunkie in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-02-2009, 10:27 AM
  6. Macro to check for blank cell entry, copy previous value, and check for duplicates
    By xPunxNotDeadx in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2009, 06:33 PM
  7. Macro to check range, if false check another range until true, then copy
    By jayers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-12-2009, 04:19 PM

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