HI!

I am looking for macro to match rows.If a row has 2 or 3 or 10 fields and is matching with any of the rows in the same worksheet then the duplicate row should get highlighted in red and should appear next to the matching row.

I tried Excel 2007 "Duplicate function but its not matching my requirement.

Thanks in advance.

Lovinguy