#REF Error in Formula after running Macro

I am nearly there...

I finally got my two major issues resolved thanks to all your help here in the Forum.

I have one last issue and then I think I am good to go.

The attached spreadsheet has a Macro to move rows based on a condition from the (Info) sheet to the (Completed) sheet.
Unfortunately when the Macro is run, the formula on the Dashboard which pulls data based on the Scheduled W/O date returns a #REF Error due to the the line being deleted by the MACRO.


Any help is greatly appreciated
juniDash - Excel Forum.xlsm