VBA to Move Row in a Sheet Based on Cell Value

Looking for some help.

Found a few VBA codes online and tried to modify them to function correctly in my workbook, but I just can't seem to make them work?

I need it to do the following:


Sheet 2 is named 'TSP Milestone Tracker' and contains the main data.

The main data is in cells B5:J10 with the headings on said data in B4:J4

Cells B5:B10 contains the status of each line

I want the VBA to do the following: If for example the data in cell B5 reads 'Complete', the entire line (B5:J5) is to be moved to another sheet named 'TSP Milestone Value' in the B5:J5 location

Each subsequent line of data marked 'complete' needs to then move to the next available line on the 'TSP Milestone Value' sheet.


Hopefully this makes sense? I can send the file over if needed.

Thanks in advance.


Edit: Sample file now attached.