If i understand you correct?

Try this
http://www.rondebruin.nl/copy5.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"hme" wrote in message ...

Hi everyone

I receive the quotes from internet in an excel worksheet everyday which
in the rows we can see the different companies name and their
infromation. Each worksheet contains variable rows and 13 columns with
the title of stock name,date.close,high,low,.....

For further analysis, I need to collect each stock in an individual
worksheet automatically[/b] (in the same workbook or other one) .It
means whenever I insert a new worksheet (download new quotes), excel
could be able to find my specific stock name and copy it and it's
related information in a specific worksheet automatically.

Unfortunately the row no. for a specific stock name and total no. of
rows vary everyday, for examle today company name A and it's
information are located on row no. 5 of 155 and tomarrow it will be on
row no. 10 of 140 and the day after ther is no company name A.

thank you very much.
hme


--
hme
------------------------------------------------------------------------
hme's Profile: http://www.excelforum.com/member.php...o&userid=15930
View this thread: http://www.excelforum.com/showthread...hreadid=274114