Here's a sample file that does what you want:
Extract1.xls 18.5kb
http://cjoint.com/?lrxHhWkbGx
Biff
"rash30" wrote in message
...
I have a large data (about 3 000 rows)where column A has product name and
column B has detailed product discription that can range anywhere from 1
to
10 rows. I want to choose a specific product name and print its complete
discription on a separate worksheet. How can I do it?
--
Thanks