+ Reply to Thread
Results 1 to 2 of 2

Micros code to compare contents in different sheets

  1. #1
    Registered User
    Join Date
    05-25-2021
    Location
    south africa
    MS-Off Ver
    10
    Posts
    24

    Micros code to compare contents in different sheets

    Good day,
    I am trying to create a macros code to look for inconsistency between two sheets. check the examples sheet below for understanding.
    I want the macros code to go to sheet 1 e.g 20M1 , then go to sheet 2 in the tag number column and look for 20M1, if it finds it,
    it much go to the corresponding description and compare it with the 20M1 description in sheet 1, if the description are the same move
    to the next row in sheet 1 (20A3) and repeat the same thing.....if they are not the same , highlight both the description and tag number
    in sheet 1 and sheet 2...Look AT THE OUTPUT FOR UNDERSTANDING


    sheet1
    tag number description
    20M1 engineering
    20A3 building
    45v342 cominissioning

    sheet2
    tag number description
    20A3 engineering
    20M1 building
    45v342 cominissioning

    OUTPUT : Highlight the first two items (both columns) because the description dont match...do nothing to the 3rd item since it is correct
    (same decription in sheet 1 and 2.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello livhu,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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] Exclude hidden sheets in Table of Contents code
    By MaggieLou in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-21-2021, 12:29 PM
  2. [SOLVED] Need to modify code to loop through these sheets and clear contents
    By g1terra in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-31-2019, 01:18 AM
  3. I need to code to clear contents the several fixed ranges of several sheets
    By samahhamaad in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-03-2016, 05:21 PM
  4. Need VBA code to compare two sheets
    By gokulg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-12-2014, 03:01 AM
  5. compare code in two sheets
    By cmccabe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-10-2014, 02:29 PM
  6. [SOLVED] Need a good Micros for splitting data into new sheets.
    By Oszie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-11-2013, 06:43 AM
  7. [SOLVED] VBA Code - Compare Adjacent Cells In two columns and clear contents when a match is found
    By Langer101 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 01-03-2013, 06:22 AM

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