I have a worksheet that summarises a data sheet that is updated by the user
by copying a file created by another application.

Occassionally the data will contian "Normal" instead of "Norm" as a line
characteristic. I have a macro that will find "Normal" on the datasheet
("JobCard") and replae each instance with "Norm".

However, I have no guarantee that the user will remember to press the button
that runs this macro.

Is it possible for the datasheet ("JobCard") to be tested after being
updated (new Job Card pasted in) and any instance of "Normal" changed to
"Norm" before the user accesses the Summary sheet, or once each time the
Summary sheet is activated?

I have tried running the macro as a worksheet event, but get myself caught
up in circular process that I have to break out of.

Any suggestions greatly appreciated
Jim
--
Jim