Hello all,

I need my spreadsheet to move entire rows when a single cell has the word complete OR deferred in it.

The word complete OR deferred will be in column J - Cant give out the actual Spreadsheet as it has confidential info on it but here is a blank on with basics on it.
Test_Move_Spreadsheet.xlsx

Please help me - I'm not very good with VBA/Macros

Thanks,
Tom