Macro to copy a few select cells from a row to another worksheet

[wr21]

I have data listed on my excel sheet, and I need help figuring out how to copy 5 specific cells from a row to another worksheet when a different cell in that row contains certain text. The cells that need copied are not next to each other.

[mehmetcik]

Lets Start with:

Please Login or Register  to view this content.

Now extend that to do what you need:

Please Login or Register  to view this content.