[QUOTE=xladept;4864584]Try this:

[CODE]Sub SumeshV():
thanks for the code.
but it may be noted that the comparison the code makes is erraneous.
there will be no comparison on day1 sheet.
on day2 sheet the comparison can only be done between E and D. see the column heading .there is data only on these two columns at present (after we run the code data from C move to D. then only the comparison should work.)

but the present code compares F2>E2 in col N
compares G2>F2 in column O
there is no data in these two columns at present.

pls see to it. thanks