Moving row to a worksheet once discharge date is filled in.

Hello, I'm extremely bad with VBA/Macros so I'm hoping you can help me.

I have two worksheets, Active Admissions and Discharge.

I have in column P, a filed for a user to enter a discharge date. What I'd like is, when this field is populated with a date, for that row to be cut and pasted in the Discharge sheet, then the data in the Active Admissions would be shifted up to fill in the gap left by the data that was cut.

Hopefully this makes sense. I'm sure this is simple, but I'm having trouble wrapping my brain around this.

Not a problem. See the attached sheet.

I've added before and after for each of the worksheets. All data inclduded is dummy data.

Inpt Call back help.xlsx

What I'm wanting to autmomate is moving the row when a date is entered into the discharge date column (Column P in the Active Admissions sheet)

Thank you so much, that works perfectly!!

Ok new problem with this. It's no longer working. I've copied the data over exactly. I set up the MACROS to run w/ ctrl+d. When I try to run it, nothing happens. even when I go back to a previous version of the file, nothing happens.

No error messages. Sheet names and layout are exactly the same. When I run the Macros, nothing at all happens. The action that's supposed to happen, does not happen. Nothing changes at all. I've verified that macros are enabled. I'm highly confused. I even tried opening a new document and copying the macros into the new document and still no luck.