Question: If found, then copy row to next sheet.

[calvinle]

Hi,

I have a sheet that I renamed wsStart and another sheet wsEnd.

In the wsStart, there are listing of member number, name and address (data in rows)

I want to do a macro that in wsEnd:
1) It will check starting, if wsEnd (cell A2) is found in wsStart (Column A), then copy the rows from wsStart to itself.
2) It will then continu to the next A3 in wsEnd, until last used rows in column A.

I know that we can do as Vlookup, but I want it to be preform with a macro instead of formula.

Thanks.

[JP Romano]

It's not pretty, but it works for me. Too much hard coding, of course, but if you're only looking for a couple of values to move back and forth, try this:

Please Login or Register  to view this content.

[calvinle]

Can't we do something such as define the column A in wsStart in a variable from A2 to last rows.
Then do a loop? Like,
X = 2 to wsStart.rows.count 'from A2 to last row in wsStart
Y = 2 to wsEnd.rows.count "from A2 to last row in wsEnd

Then make a search:
If value in A2 of wsEnd = one of the value in column A2 to last row of wsStart, then copy that row and paste it into A2 of wsEnd.
Then next range...

Thanks.