filtering out data using other worksheet

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

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" <Jaypee@discussions.microsoft.com> wrote in message
news:533C281E-1105-4AE4-A006-03164EE9DC68@microsoft.com...
>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