Results 1 to 7 of 7

Compare 2 sheets, Highlight 2 new column entries

Threaded View

  1. #1
    Registered User
    Join Date
    08-07-2013
    Location
    Texas
    MS-Off Ver
    Microsoft Office/Excel 2019 for Mac
    Posts
    39

    Compare 2 sheets, Highlight 2 new column entries

    Every week I pull a report showing out of stocks. It shows a unique number for each customer 'Customer' in Column H. It shows a unique number for each product 'ASW#' in Column L. There are many common columns. What I am trying to highlight for myself is when a new customer with a new product shows up on the latest week's report showing me that as of this week that customer did out of stock on the particular product.

    I pull this report weekly but it can only be pulled on the month's numbers, so in this case March 2020. I have been manually comparing. When I get to the end of a month there will be repeats of customers as it will include customers that would have been out of stock the week prior too. I start missing line items.

    I've attached a sample of the Excel spreadsheet. If there is a good formula I can use, great! If I need to create some other reference columns or data just let me know. The real spreadsheet has a tab for each week of the month.

    In other spreadsheets where I compare inventory levels only, I have a 'Latest' Spreadsheet tab, 'Previous' Spreadsheet tab and then the 'Compare' tab and use VLOOKUP, BUT this just compares one thing. What I don't know how to do is identify the customer AND the ASW# as new for the week.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Compare Two Sheets and Highlight Differences
    By Blake 7 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-12-2015, 11:44 AM
  2. [SOLVED] Compare two sheets, highlight differences
    By papasmurfuo9 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-11-2014, 05:12 PM
  3. [SOLVED] Compare name list (First name, last name) on two different sheets and highlight
    By badboynads in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-25-2013, 07:37 AM
  4. [SOLVED] Compare column on separate sheets in workbook and highlight differences
    By specialk610 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-22-2013, 03:57 PM
  5. Compare two data sheets for common entries
    By anikamenon in forum Excel General
    Replies: 3
    Last Post: 11-17-2012, 12:16 PM
  6. [SOLVED] Need to Highlight New Entries Between 2 Sheets in Same Workbook
    By Whit804 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-30-2012, 11:48 AM
  7. Highlight duplicate entries from multiple sheets
    By alinpion in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-17-2011, 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