Combining Worksheets

[Angel]

Hello All, I have 2 worksheets with rows (and rows) of
customer data in several (8) different columns. One
worksheet(A) lists all customers and the other worksheet
(B) lists all customers based on certain criteria.
Worksheet B is far fewer than A. I can't figure out a way
to list on one worksheet all customers that are appearing
in workshet A unless they are represented in B. In other
words, some A people are not on B, but all B people should
be removed from A. Does that make sense?

I would REALLY appreciate help or at least a direction
(some keywords to search even). I'm at a loss.

Thank you All,

Angelj

 

[Frank Kabel]

Hi
see your other post in Excel.worksheetfunctions