+ Reply to Thread
Results 1 to 5 of 5

Highlight duplicates data form sheet to another sheet

  1. #1
    Registered User
    Join Date
    10-17-2015
    Location
    Kosovo
    MS-Off Ver
    My Microsoft Office Version: Microsoft? Excel? for Microsoft 365 MSO (Version 2403 Build 16.0.17425.
    Posts
    66

    Highlight duplicates data form sheet to another sheet

    Basically I have a spreadsheet which shows months Sep ,Oct, Nov and Dec we have to tracking ID number so if ID number is sheet Sep or Oct I want to highlight it as duplicates data so that case I am informed that ID number has been last month. What I am trying to do is highlight duplicate ID Numbers across the worksheets as we shouldn't have the same ID Number in the two different sources.
    See attachment.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    08-07-2014
    Location
    Quito, Ecuador
    MS-Off Ver
    Excel 2016 & 365, Windows 10
    Posts
    511

    Re: Highlight duplicates data form sheet to another sheet

    Checking your file, there are a lot a duplicated values in every filled tab....

    So, as per your example:
    you can have duplicated numbers in the same tab, but you want to highlight if the number you are entering is already in any previous tab?
    Barriers are there for those who don't want to dream

  3. #3
    Registered User
    Join Date
    10-17-2015
    Location
    Kosovo
    MS-Off Ver
    My Microsoft Office Version: Microsoft? Excel? for Microsoft 365 MSO (Version 2403 Build 16.0.17425.
    Posts
    66

    Re: Highlight duplicates data form sheet to another sheet

    I have numbers in two sheets in the same excel workbook. I need to compare the data in Column C:AI, Sheet (Sep) with the data in C:AI, sheet (Oct) and highlight the duplicates.

  4. #4
    Valued Forum Contributor
    Join Date
    08-07-2014
    Location
    Quito, Ecuador
    MS-Off Ver
    Excel 2016 & 365, Windows 10
    Posts
    511

    Re: Highlight duplicates data form sheet to another sheet

    Check the attached file..:

    I've placed in tab "Oct" a formula in conditional formating for the table area, and only 4 values are not repeated in tab "sep"
    take care of the new table I made down the original. It is used only for showing how it works, not needed for the formating.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-17-2015
    Location
    Kosovo
    MS-Off Ver
    My Microsoft Office Version: Microsoft? Excel? for Microsoft 365 MSO (Version 2403 Build 16.0.17425.
    Posts
    66

    Re: Highlight duplicates data form sheet to another sheet

    thank you

+ 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] Avoid Duplicates Entry on Pasting Data from one sheet to another sheet
    By chergian in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-07-2014, 03:33 PM
  2. [SOLVED] Copy data from one sheet (multiple cells) to another sheet in tabular form
    By dvs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-19-2014, 12:13 PM
  3. Compare 2 sheets, highlight duplicates on sheet 2
    By rubybegonia in forum Excel General
    Replies: 1
    Last Post: 02-17-2014, 05:33 PM
  4. [SOLVED] How to copy data range form one sheet to other sheet with desire Reverse Transpose ?
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-18-2013, 12:30 PM
  5. Copy Data from a fixed form of data sheet into a master excel sheet.....
    By sirimhk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2012, 08:48 AM
  6. highlight duplicates from one sheet to another
    By nair.harish in forum Excel General
    Replies: 0
    Last Post: 07-29-2011, 06:12 AM
  7. highlight duplicates on another sheet
    By dcutts666 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2007, 12:39 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