Hi Jaypee,

See Chip Pearson's Highlighting Duplicates page at:

http://www.cpearson.com/excel/duplic...tingDuplicates

See particularly the section entitled:

'Extracting Values On One List And Not Another'


---
Regards,
Norman



"Jaypee" wrote in message
...
I have two worksheets, say worksheet wsA and wsB....
wsA and wsB are related by one field, say field1

I want to show only all data from wsA that does not have a matching data
in
wsB.

What should I do? Thanks in Advance