Appointment Scheduler - tracking visits across worksheets

.
.
You could forego the use of macros and formulas if you desire, by using the FIND function built-in to Excel. Refer to this pic:
.
.
Find All.jpg
.
.
I retired from the medical field and am aware of the problem with data being entered in different formats. I presume patient names are derived from the hospital master database ... so every
time a name is entered into your scheduling worksheet, it will be spelled the same each time ? If not, you're going to run into difficulties finding all the matches.
.
You might try including the patient's MRN and search by that. Except for the issue of a patient being given more than one MRN due to multiple registrations. I'm certain you can work out that
challenge ?

HTH

Thank you Logit. I am currently using Excel Mac 2011 so I couldn't find that FIND ALL function but it looks like that could work. We use microsoft at work so that will probably work there.

I didn't notice you were running a MAC. I'm certain the menu command is probably in the Mac version, just have to find it.

Glad the suggestion helps you. Best wishes.

Cheers !

ps: Thank you for the add rep !!!

Thank you Bakerman2,
My manager and I were thinking that it will mainly be me that will have access to make changes to the document. Currently, I make a copy of the schedule and send it to them so they know who they're seeing that day. I'll add the userform because I do agree that it'll make it easier writing down the correct patient name, but then I don't know if i'll be able to write the visit number next to it for each diff. appointment?