Move Row in Excel Sheet VBA

[matt85webb]

Good afternoon,

I am trying to move entire rows from one sheet to another with a VBA code. I was trying to input it but I cannot figure it out. Essentially I am have a sheet and if their code in column C says term it will automatically move to the term page.
Roster.xlsm
If anyone could help that would be greatly appreciated!

[xladept]

Hi Matt,

This seems to work:

Please Login or Register  to view this content.

[matt85webb]

Thank you very much! I do have one question, it seems that it only does terms up until about row 50 and then the VBA no longer works. Do you know what would cause this?

[xladept]

Hi Matt,

Thanks for the rep!

Maybe column A is empty? Try this:

Please Login or Register  to view this content.