Excel Question #46

Moonliner · 04-02-2009, 03:58 PM

Quote:

Originally Posted by 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!

If I read this correctly, It sounds like an issue with the export. Does the daily log you receive include these records that were updated, or just ones that were created since the last log was created?

Kevy Baby · 04-02-2009, 04:05 PM

Quote:

Originally Posted by Moonliner

If I read this correctly, It sounds like an issue with the export. Does the daily log you receive include these records that were updated, or just ones that were created since the last log was created?

It is not an issue with the data: I need to be able to see when the data has changed after being entered. Note that I cannot control the data (I export it from a legacy system into an Excel file to download).

The recent issues was when the Delivery Appointment date was originally set for 3/26/09 and was entered as such. Due to weather delays, the Delivery Appointment was delayed until 3/30/09. Unfortunately, since I only look for new data, I did not see that they had changed the date (which, as you might guess, is a problem).

Moonliner · 04-02-2009, 04:43 PM

Quote:

Originally Posted by Kevy Baby

It is not an issue with the data: I need to be able to see when the data has changed after being entered. Note that I cannot control the data (I export it from a legacy system into an Excel file to download).

The recent issues was when the Delivery Appointment date was originally set for 3/26/09 and was entered as such. Due to weather delays, the Delivery Appointment was delayed until 3/30/09. Unfortunately, since I only look for new data, I did not see that they had changed the date (which, as you might guess, is a problem).

So my question is, do the log files as currently created include these edited records?

If No: Then you need to re-write the log file generator. Hopefully, in addition to the date_created field (I assume that's what you are looking at the create the log file) there is also some type of date_changed or date_updated field.

If Yes: Then you need to rewrite your import routine to allow for these new records.

Drince88 · 04-04-2009, 10:46 AM

WAY outside the box and cludgy, but maybe it will trigger your creative juices for a better fix.

Have two versions of the formatted worksheet in a workbook. Put the new data in 'sheet 2' and have it conditionally formatted to turn red (or whatever) when the data does not equal the same data in sheet 1, which was the previous version of the data.

04-04-2009, 10:46 AM	#4
Drince88 Senior Member Join Date: May 2005 Posts: 481	WAY outside the box and cludgy, but maybe it will trigger your creative juices for a better fix. Have two versions of the formatted worksheet in a workbook. Put the new data in 'sheet 2' and have it conditionally formatted to turn red (or whatever) when the data does not equal the same data in sheet 1, which was the previous version of the data.
	Submit to Quotes