| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
