how to identify whether cell data manually typed or copy paste

[ajayp]

how to identify whether cell data manually typed or copy paste,Can we use some formula, so that the add text colour will change if pasted.

 

[bobhc]

You need some VBA code the last entry in the link may help you.

http://stackoverflow.com/questions/...detect-if-something-was-pasted-in-a-worksheet


.

 

[ajayp]

You need some VBA code the last entry in the link may help you.

http://stackoverflow.com/questions/...detect-if-something-was-pasted-in-a-worksheet


.

its not working for me
can you please give some sample file to check with step to generate.

In row G8:G500 if user copy paste the earlier data from past sheet the added data colour must be changed to red or any other way to identify within same cells.


thanks in advance

 

[Deepak]

Check this..