Search Value from selected range and copy row to new worksheet

[Shermaine2010]

Search defined value from selected range then copy row to new worksheet.

The sample was created at file attached. Please help.

[Keebellah]

Based upon what you have asked I have written some code and put it the attached file

[Shermaine2010]

Based upon what you have asked I have written some code and put it the attached file

It look great. Let me study study first. Anything, I ask you again.
Thanks

[Shermaine2010]

Based upon what you have asked I have written some code and put it the attached file

I add in advance filter search for multiple criteria. however I got syntax error fpr below code

Please Login or Register  to view this content.

[Keebellah]

Well, when you decide to use the code provided and you edit it then you should keep in mind that you show do it correctly.
It's full of errors and missing references, all in incorrect order and the error you show is due to the fact that you forgot to place an _ after the Copy, to indicate that the following line of code belongs there, well, to make it short, when you copy and use, check the code, step by step

Here's the corrected version with the modifications, I hope this is the result you wanted.

BTW you CANNOT select a range in a worksheet if it's not active !!!

Please Login or Register  to view this content.