Auto find a specific row and copy it to another worksheet

H

hme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top