+ Reply to Thread
Results 1 to 2 of 2

comparing columns from 2 different sheets and highlighting any date differences

  1. #1
    Registered User
    Join Date
    01-07-2014
    Location
    Columbus,Ohio
    MS-Off Ver
    Excel 2010
    Posts
    8

    comparing columns from 2 different sheets and highlighting any date differences

    I have report that runs everyday to show open sales orders and commit dates of those orders. It exports out of our WMS into excel, we have several macros that run on it to remove the columns we don't need. If the sales order has any changes made to it during the business day our WMS assigns a new lead time of 7 days out from the date of the change. So if my commit date today is 2/17 and changes are made today the new date is now 2/25. However, even with those changes the original date to the customer is what we go by but when the report runs the new date is all we see. We need to be able to see when dates change from day to day without having to compare line by line of this report. I can't change how the WMS works so I need my excel sheet to compare columns A (sales order) and J (commit date) from today to yesterday's columns A and J and then either highlight or having a neon flashing sign on the date or the sales order line or something in today's sheet if they are different.

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: comparing columns from 2 different sheets and highlighting any date differences

    You need to supply a sample workbook so we have something to work with.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

+ 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. Comparison of 2 sheets from different workbooks and highlighting the differences
    By zsimur in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2013, 07:31 AM
  2. [SOLVED] Comparing two sheets for differences
    By papasmurfuo9 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-16-2013, 06:43 AM
  3. Highlighting Differences between 2 Columns
    By ZackG in forum Excel General
    Replies: 3
    Last Post: 02-24-2011, 10:32 AM
  4. Comparing columns and highlighting differences
    By Sejrup in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-01-2010, 09:24 AM
  5. Comparing two workbooks and highlighting the differences
    By Charles C. in forum Excel General
    Replies: 2
    Last Post: 07-26-2006, 02:20 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