Macro to move data fields?

[FireMarshal]

Can I use a Macro that will move the completed project fields to a different worksheet automatically?

[watersev]

hi, FireMarshal, yes you can

[FireMarshal]

hi, FireMarshal, yes you can

That is great to hear Watersev! Can you share how to develop this macro? All columns of completed projects will be moved as the projects are completed. I assume I would SORT the data and block the section to be moved, but I need some help developing the Macro. Any help is appreciated!

[watersev]

post sample workbook showing original data and the result you need to obtain

[FireMarshal]

Thanks again Watersev. I have attached the File. This is an Inspection Project Log where I schedule and monitor inspections. When completed (by Inspection date) I would like to sort amd move the selected data to another worksheet (yet to be made.) Any help would be appreciated!
FireMarshal