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.
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By zsimur in forum Excel Programming / VBA / Macros
Last Post: 10-31-2013, 07:31 AM
By papasmurfuo9 in forum Excel Programming / VBA / Macros
Last Post: 07-16-2013, 06:43 AM
By ZackG in forum Excel General
Last Post: 02-24-2011, 10:32 AM
By Sejrup in forum Excel Programming / VBA / Macros
Last Post: 09-01-2010, 09:24 AM
By Charles C. in forum Excel General
Last Post: 07-26-2006, 02:20 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1