Try to use Autofilter.
DataFilterAdvance FilterCheck mark on Unique Record Only.
See more info in the HELP.
Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Free addins Office Menu-2003 for Office-2007)
If You Can't Excel with Talent, Triumph with Effort.
wrote in message
oups.com...
Say, I have a worksheet that has Column A for work orders, Column B
for parts
A work order may contain many parts on different rows:
Column A Column B
WO123 PN5
WO123 PN6
WO123 PN7
WO121 PN9
WO122 PN4
WO122 PN7
etc
I want to automatically "look up" a work order and "import" the parts
used into another worksheet - to create a "flat/horizontal" statement
like "WO122 used PN4 and PN7". How do I do this?