Hi,
I was hoping someone can help. I work as an analyst in a hospital.
I have attached a sample report with a before & after and a 3rd sheet that I get the discharge info from. 3 columns in my report that are important to my work:
Column 1 - Patient number
Column 2 - Admission date
Column 3 - Discharge date
I can pull off a separate report from the system which has details of discharged patients:
Column 1 - Discharge date
Column 2 - Hospital number
Please can someone tell me if there is a formula/macro to quickly fill Column 3 with discharge dates for patients who have discharged and have it not affect any other cells.
Bookmarks