Dear Tom

Tanke you very much

It is working :) but I need to improve this macro.
whenever I run macro it find and copies the right row from sheet1 t
row no. 2 of sheet 2.and by running again it copies the same row in th
next row in sheet2 and it repeats this.

I need more your help

Assume there are 10 worksheets in workbook A:
I need a program can be able to copy the right rows from these 1
worksheets into sheet1 of workbook B .It means the first row o
sheet1(workbook B) comes from sheet1(workbook A),next row o
sheet1(workbook B) comes from sheet2 (workbook A) and if there is n
my text in sheet2 comes from next sheet (workbook A) and so on. an
whenever I insert a new worksheet e.g. sheet11(workbook A) it can b
extract the right row and put in the next row in sheet1(workbookB).

it will be very helpfull If it can be copy not entire row just up t
column no. 13.

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=27415