Excel Question #46

[Kevy Baby]

Okay Moonliner (or Alex, GD, BTD, Andrew, or anyone else who might now).

I have a daily log that I get. Because the raw data is not in a format I can present to the client, I copy and Paste Special > Contents the relevant data into my pre-formatted spreadsheet. The majority of the data basically gets entered when a shipment is arranged. As delivery information (such as "Delivery Appointment" and "Actually Delivery" dates) is updated, it is added to the data and gets copied into my formatted spreadsheet during the copy paste step.

However, I have recently discovered that on a rare occasion, the delivery appointment is chaged after first being entered. While I know it has happened in the past, the way I import the data, I do not see this change (I am only looking for NEW information in the data).

Is there a way to highlight when previously entered data changes in the process described above? I don't even know where to begin on this one.

HELP!