Extract a given row from progressive worksheets
 

Hi

Somebody Help me


I am looking for a program to find the row with a given text (e.g
"companyA") in the 2 th column from workbookA/sheet1 and copy this ro
up to 13 th column to workbookB/sheet1/first row and again fro
workbookA/sheet2 (if the there is any "company A") to
workbookB/sheet1/next row.

this program must be progressively. It means whenever I insert a ne
worksheet in workbookA this program should be be able to extract th
requested row (if there is any) and copy it into the next row o
workbookB/sheet1.

It is very useful in stock market.

thank you in advance.
regards
sohrab hashem

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