Hi everyone

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

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

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

thank you very much.
hm

--
hm
-----------------------------------------------------------------------
hme's Profile: http://www.excelforum.com/member.php...fo&userid=1593
View this thread: http://www.excelforum.com/showthread.php?threadid=27411