Re: How to move entire row to another sheet based on cell value in Excel

I have copied this code, changing the sheet names and the column location for the criteria I want moved to another sheet. I run the macro and nothing happens.

My sheets are "Monitoring Invoices" (source) and "NOT ASSIGNED" (target). The criteria "Not Assigned" is in column C.

The Monitoring Invoices sheet grows each month, so I need the Not Assigned rows to move to the NOT ASSIGNED sheet and accumulate for review.

Can you assist me by editing what you have provided to fit my needs? I'm new to VBA and can't figure out what I'm doing wrong - THANKS!