#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

First a gentle chiding ... It would have saved some time (and probably elicited a response fro someone sooner) if you had included an explanation as to what worked and how.

I did look in the VBA for a module - which is where I would normally expect to see a macro and there isn't one. So then I decided to abandon it as too much effort. But a cup of tea arrived so I gave it another chance and I found some code for the INFO sheet. I assume this is "the macro"


Essentially this runs for a worksheet change event where you are changing the status to "Closed"

You get the #REF because the formula refers to a row that no longer exists. So you have a choice:
1. delete the row on the Dash sheet
2. or, change the formulae on the INFO sheet so that they survive the row deletion. OFFSET from a header row works well
3. or, reset the formulae after the deletion

Basically you get the #REF