Search and Update or Create New Entry

Hello Friends!

Grey here again! I am really learning a lot from this forum as you fellas are doing some excellent work!

So, here is another challenging excel problem I am facing.

My boss has a huge database of patient records, and he wants several of us to start updating that data with new information.

In the workbook, there is a master sheet and several other sheets that our staff maintains.

My boss wants us to be able to enter the unique medical record number (MRN) for a patient in our sheet, have the record for that patient be copied over to our sheet from the master database (if the record exists), and then have any new information we enter for that record be updated back on the master database.

If we enter a MRN and the record does not exist in the master database, my boss wants a new entry to be created both in our sheet and in the master database. (a possible scenario is that we have a popup msg that asks us if we want to create a new entry).

Also would it be possible to have some kind of sheet ID display next to the record on the master database as a reference to the sheet that a particular record was last updated from?

I have attached a sample workbook with an example. One problem might be that not all the worksheets have every column that is on the master database. So column matching might also need to be coded in somehow.

Let me know if you guys need any further clarification. Also, do you guys have suggestions for any other database programs that might make managing something like this easier?

Thanks a bunch!
Grey

anyone? any help would be appreciated!