Need a macro that will delete/add row

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

Main data is in new inventory, which is being referenced in scrap log.

1.) Delete row 2 in New inventory. This will create a "#REF!" error in row 2 of Scrap Acitvity Log.
2.) Run a Macro that will delete row 2 in the Scrap activity Log.
3.) Then Move all rows up to keep formulas intact. - The same logic as when you delete a line and the next row automatically moves up.

I should be able to delete any row in New Inventory and run this macro and it will find the "#Ref!" and delete the entire row.

Ok, that works thanks. Now say that if I wanted to add a new row of data on the new inventory worksheet and wanted my formula to continue when I add a New row of data. Could I incorporate that into this delete function.

Can I start the Macro when I open the document and when I delete the row it deletes the rows in scrap activity. Because I would have to run the macro every time I delete a row rather and it being automated and just does it upon deletion of a row. Yes that is fine as long as the next row following the one that was deleted will move up and the the formula stay the same.

Step 1. Load macro on opening of document and run in the background.
Step 2. Delete a row from the worksheet "New Inventory"
Step 3. "#REF" - is created in "Scrap Activity log" when the row is deleted from "New Inventory"
Step 4. Macro will auto-delete the line once it scans for error in rows.
Step 5. All data in "Scrap Activity will then shift up to the next row.
Step 6. A new row will be created after the last row and the formula will be continued in this new row.