I have a document that I want to be able to delete out of any row, start a macro that will delete that row out of another sheet where I am referencing that data. Once that operation is done I want the row to move up and my formulas in the next row will stay intact.

Copy of US05 - MPTS_test version.xlsm