If a formula approach is required/needed, see my post in:

http://www.mrexcel.com/board2/viewtopic.php?t=144521

snugs25 wrote:
if i have a list of data on sheet 1 and a list of similar data on sheet 2,
how can i arrange it so that automatically sheet 1 will filter sheet 2 and
only highlight (show) the information that they both share? so for example on
sheet 1 there are a list of names, barny fred wilma betty and dino.....on
sheet 2 there is a list of names barny betty and dino...how can i make it so
that sheet one filters this and shows the names they have in common only?

Sorry if its a bit confusing