How can I detect if something was copied and pasted?

[patlsu02]

I am looking for a way to determine if a cell’s value was copied from one cell and pasted into that cell. Reason being is I am in charge of a worksheet that is used to record dimensions of something. These inspections are completed hourly by other employees. According to the data collected there is always some kind of variation. Occasionally, there will be an employee who may be bucking the system by just copying the dimensions from a time period earlier and pasting it into the next cells. I’m looking for a way VBA code, conditional formatting, etc. to determine if that value was recorded in that manner. This may not be so clear on past worksheets, but moving forward is there a way to hide code or formatting to determine if this happened?

Example:

A B C D E
1 .3 .2 .3 .2 .2
2 5 5 5 5 5
3 .1 .1 .1 .1 .1
4 Y Y Y N N
5 2 2 1 3 1
6 T F F F F

I would like to determine if the values in B3, C3, D3, and E3 were copied and pasted or if the value in A3 was dragged to copy them. Is this possible?

Thanks,

Pat

[mikerickson]

One can test if the data is an exact duplicate of preceding data. One cannot test how it got there, e.g. typing or copy/paste.