Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto copy a raw from a worksheet to another.
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto copy a raw from a worksheet to another.
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet auto text copy | Excel Discussion (Misc queries) | |||
Worksheet Text Auto Copy | Excel Discussion (Misc queries) | |||
auto copy to new worksheet | New Users to Excel | |||
AUTO-COPY INFORMATION FROM ONE WORKSHEET TO ANOTHER | New Users to Excel | |||
auto insert copy of worksheet | Excel Programming |