View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default Cell A1=range from B1-B10

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