Sounds like you should import your data into an intermediary table so that A script and a relationship between it and your main file can be used to compare data on a layout where you can see the data in each record of each table. Then buttons/scripts can be used to move the data you want to be moved into your main table
Hopefully, there is a column in the Excel data that uniquely identifies each patient. If so, then you can set up a relationship matching records in the two tables by this field.
As to deceased patients. What data in the Excel file identifies a patient as "deceased"? There no longer is a row with that patient's ID? There's a column that has a value in it if the patient is deceased? Or ???
Thank you! Worked perfectly.
A deceased patient is simply removed as a total row from the spreadsheet. We have other fail-safes in place to catch this so its not a problem to leave this.
Thanks again for your help.
Then a layout where the newly imported data is compared to your existing data can show which patients are deceased as there will be a record in your main table that no longer matches to a record in this intermediary table.