Macro to move complete row from one worksheet to another

[Kimston]

I am new to VBA, but I am trying to hove rows from one worksheet to another if a value in column B is met. For example, if Column B has the work "term", then I would like this macro to copy the entire row even if there are empty cells in the column. I have this piece of code, but it does not work as I expect. Your well is well appreciated.

Please Login or Register  to view this content.

Thank you very much for you help

[jindon]

Do you mean like this?

Please Login or Register  to view this content.

[Kimston]

Hi Jindon,
Thank you for your quick response. I tried your code and the only thing that I see is that if there are more than one term in difference rows, for example, if there is a "term" one in row 5 and then another one in row 13, the macro does not select all of the filtered "term" and copy into the Terms worksheet. Is there another way to accomplish this if there are several non sequential order?
Thank you for your help.

[jindon]

Try this one then

Please Login or Register  to view this content.

[Kimston]

Thank you, Jindon for your help. This code worked perfectly.

[Kimston]

Mr. Jindon,
After using your VBA code, I noticed that it doesn't compy my formulas. It converts them into values.
I was thinking if I can use

Please Login or Register  to view this content.

instead of Copy.
I would like to copy and paste the entire row it is possible.

[jindon]

Formula?

There was no formula used in the sample.

Please Login or Register  to view this content.

[Kimston]

Hi Mr. Jindon,
I tried your new code and it works perfectly. Thank you very much for your excellent help!