I have data from different months (February & March) lots of the data remain similar. I want to know if there is a way to identify what has changed between the data set and then generate a new sheet that only has the changes between the two months. Attached is the Data Set for reference. I placed March and Feb in different work sheets. Please help
My old process was that I used to comb through all the data set and use the data I need. And replace all values. If there was a way I could determine what was change, I would only need to replace those values in a different table I need to make.
Please Help.
I really only care if column I has changed in respect to Column E, F, & G
Column E is the name
Column F, G, & I are attributes of column E
Column F & G describe the range of which Column I is an attributed to the Name in Column E
Example:
Route 1245 (COLUMN E) has an MAOP of 890 (COLUMN I) between 0 (COLUMN F) - 400 (COLUMN H),
Id like to know when the MAOP (I) with respect to E, F, & G has changed (if it does)
Id like to know when F & G has changed with respect to E (if it does)
Finally if there is a change to any attribute to F, G, and/or I, I'd like to know on which Route (E) it happens on.
If you can imagine a simpler process to do this please share Changes Excel Help.xlsx
Bookmarks