Extract a given row from progressive worksheets

H

hme

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
 

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

Similar Threads

Copy Worksheet to specific row in another workbook 0
Auto find a specific row and copy it to another worksheet 0
Data Validation - using a list from another workbook 4
VBA code To Merge All .csv files into a single excel sheet (data start from row 11th) 2
Array with many cells from a row but not in order or together 11
Using VBA to Copy Ranges to a PreSet Dim formula AND Cell Propertys. 0
Dynamic Array not response 5
VBA - Insert row, copy contents of original row except for contents of column A 3

Top