You can use the autofilter option (Data - Filter - Autofilter). It will
show a drop down on the part number, and selecting one element will hide all
the lines but the ones that have that number on them.

Hope this helps,
Miguel.

"Ashley Morris" wrote:

Hi, all.
I'm trying to figure out how to display all the contract numbers that relate
to a single part number (see example below) so Product Managers can reference
them easily. The "perfect world" situation is where they can clink on a part
number or link and a list of all contracts would be displayed.
All suggestions welcome! Thanks!


0-0069338-1 AAYPC109/00
0-0069338-1 NCYMISC-NC-AMP
0-0069338-1 TAYSP10104
0-0069338-1 3OYMISC-VB-AMP
0-0069338-1 VUYTS2004
0-0069338-1 WWYMISC-WP-AMP