filtering between spreadsheets

[Guest]

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

 

[Guest]

Just a thought.....for a no-macros, no-formulas, occaisional use approach:

Assumptions:
Sheet1 has the complete list in Col_A with A1: Names
(Names,Fred, Wilma, Barney, Betty, Dino, Bam-Bam, Pebbles)

Sheet2 has the abbreviated list in Col_A with A1: Names
(Names,Fred, Barney)

On Sheet1:
Select the Names list
Data>Filter>Advanced Filter
Select: Filter the List, in Place
Criteria Range: (Switch to Sheet2 and select the Names range)
Click the [OK] button

That should filter the Sheet1 list in-place to only show items that are also
on Sheet2.

Data>Filter>Show All to turn off the filter

You could also select to Copy to Another Range if you want to park the
filtered data in another section of the worksheet.

Does that help?

***********
Regards,
Ron

 

[Aladin Akyurek]

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

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