Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filtering between spreadsheets
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filtering between spreadsheets
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 DataFilterAdvanced 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. DataFilterShow 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 "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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filtering between spreadsheets
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheets are cut off when you paste and link? | Excel Worksheet Functions | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
Problem with link cells between 2 spreadsheets | Excel Discussion (Misc queries) | |||
Linking between spreadsheets does not work unless I have both spr. | Excel Discussion (Misc queries) | |||
Compare two spreadsheets to find differences. | Excel Discussion (Misc queries) |