macro to find value in cell and copy that row to toher sheet

[jayers]

Hi - I am working on getting a macro to find a name in column "B" and once found copy its row to another sheet.

I have been working on an "IF" statement that checks for the given name and if true copies the row. I can not get it to keep checking and then stop using "loop"

What i got so far:

Please Login or Register  to view this content.

Can anybody help?

Thanks - JimA

[shg]

Explain your intended logic?

[jayers]

I got it to work -
it goes like this:

Please Login or Register  to view this content.

Thanks for all your help - Jim A