+ Reply to Thread
Results 1 to 3 of 3

two columns of data on separate sheets mark the data that does not exist

  1. #1
    Registered User
    Join Date
    02-13-2017
    Location
    kaplan,la
    MS-Off Ver
    2013
    Posts
    3

    two columns of data on separate sheets mark the data that does not exist

    ok I will try to explain the best I can, I have two sheets one with lots of data the other is a report I do, on sheet1 column1 I have a list of unit numbers ex 1,2,3,4,5 on unit per row. on sheet 2 column1 I have the unit numbers again but here the numbers repeat with different data accompanying them also sometimes there is a new unit number. I need to somehow compare sheet1 and sheet2 column1 and find the new unit number and either highlight it on sheet2 so I am aware there is a new number or even better copy the new number and insert on sheet1. I have tried conditional formatting not working. sheet1 column1 will only have unique numbers 1 ,2,3,4 etc where sheet2 column2 will have repeats 1,2,2,2,3,1,2,1,3,7 etc I need to that 7. I hope this makes better sense then my last try at help
    I am very new at excel

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,463

    Re: two columns of data on separate sheets mark the data that does not exist

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Quang PT

  3. #3
    Registered User
    Join Date
    02-13-2017
    Location
    kaplan,la
    MS-Off Ver
    2013
    Posts
    3

    Re: two columns of data on separate sheets mark the data that does not exist

    ok I attached a sample file, as you will see on sheet2 12,15,18 are not on sheet1 I need a way to mark 12,15,18 and if possible to add the missing unit number in sheet1 at bottom of list
    Attached Files Attached Files

+ 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. VBA Code to Separate Data from Columns into New Sheets
    By leafsfreak12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2015, 10:21 AM
  2. [SOLVED] Macro needed to Concatenate data in 2 separate tables of 2 separate sheets
    By 823 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 02-08-2015, 02:02 PM
  3. Replies: 0
    Last Post: 02-13-2013, 02:22 AM
  4. Replies: 3
    Last Post: 06-12-2012, 01:33 PM
  5. Mark intersecting cell "Yes" if both Column and Row Headers exist in raw data as a pair
    By tenscourts in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-02-2012, 04:30 PM
  6. Replies: 4
    Last Post: 11-22-2010, 12:57 PM
  7. Replies: 3
    Last Post: 08-12-2010, 03:45 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