Hi
I have been reading old posts but couldn't find an answer to my prob.
I have two sheets "sales" and "salesold". They have the same fields.
What I want to do is compare "sales" to "salesold" and copy the
different rows into "compare" sheet.Comparing colums are "n" and "m"
ie.

- check value in "n" first if "salesold" doesn't have it then copy row
to "compare" from "sales".
- if "salesold" has it then check "m" column.If the "m"'s is the same
do nothing if different then
copy the row to "compare" from "sales".

Sheet "sales" has all the data which "salesold" can contain of
course.

Any direction ? Thank you very much in advance.