+ Reply to Thread
Results 1 to 5 of 5

arrange & highlight data between two sheets based on column

  1. #1
    Forum Contributor
    Join Date
    05-08-2021
    Location
    ALQUDS
    MS-Off Ver
    2019
    Posts
    261

    arrange & highlight data between two sheets based on column

    hi experts
    I have the right data in sheet MAIN and I fill data manually in sheet ENTER sometimes I make mistake or leave some cells and when correct manually it will take more time . so I search fast macro to deal with this data and in future it will reach at least 1500 rows .
    it should match data between two sheets based on column B and search the wrong data in column C , D,E or missed values in some cells which contains empty cell or items are not existed in sheet ENTER based on column B with the right data in sheet MAIN in columns C,D,E .after correcting the data in sheet ENTER . it should highlight cells which contain wrong value by yellow color ,if there is cells are empty (this means missed some items) then should highlight by red color and if there are many items are not existed in sheet enter. just to understand how data show . it will bring them and highlight by blue color . the result should be in sheet ENTER . there is no sheet OUPUT and should highlight the data are existed in sheet MAIN and are not existed in sheet ENTER
    I hope to I covered all of details without any confusing .
    thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: arrange & highlight data between two sheets based on column

    So I put this in a new module:

    Please Login or Register  to view this content.
    But then perhaps you want to automatically fill in data when you enter the value in Column B so I put this in the module for the ENTER sheet:

    Please Login or Register  to view this content.
    WBD
    Attached Files Attached Files
    Last edited by WideBoyDixon; 11-11-2021 at 06:50 AM.
    Office 365 on Windows 11, looking for rep!

  3. #3
    Forum Contributor
    Join Date
    05-08-2021
    Location
    ALQUDS
    MS-Off Ver
    2019
    Posts
    261

    Re: arrange & highlight data between two sheets based on column

    thank that's great ! but you forgot somthings . should highlight blue color in sheet ENTER for new data and the same data should highlight by red in sheet MAIN . see the rows below in sheet ENTER & MAIN .you will understand it

  4. #4
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: arrange & highlight data between two sheets based on column

    Umm. OK. Try this macro then:

    Please Login or Register  to view this content.
    WBD

  5. #5
    Forum Contributor
    Join Date
    05-08-2021
    Location
    ALQUDS
    MS-Off Ver
    2019
    Posts
    261

    Re: arrange & highlight data between two sheets based on column

    many thanks for your solution

+ 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] Match between two sheets and bring missed elements based on column and arrange again
    By abdo meghari in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-24-2021, 10:46 AM
  2. [SOLVED] Arrange column data from multiple sheets based on two columns each sheet has.
    By Choochi in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-01-2020, 07:49 PM
  3. Replies: 3
    Last Post: 07-28-2016, 10:54 AM
  4. [SOLVED] Excel VBA code required to re-arrange the data based on Column condition
    By mchilapur in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-28-2015, 03:48 AM
  5. Replies: 2
    Last Post: 08-04-2014, 08:57 AM
  6. Highlight Data Based on Data in Another Column
    By JohnYuhaschek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-27-2014, 04:25 PM
  7. highlight duplicates based on multiple column data
    By just_some_dude in forum Excel General
    Replies: 4
    Last Post: 08-31-2012, 01:37 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