Data Comparrison

[kelthomp]

Hello,

I hope some genius out there can help me. This forum has provided me many answers in the past but I cant figure this one out. I have attached a spreadsheet with two tabs. What I am trying to accomplish is a filter (maybe) that will look at the assignments sheet (sheet1) and the staff name with individual patient ID numbers and filter through sheet two and tell me who the patient was assigned to from sheet 1 and all of the other staff members that made a visit to that patient from sheet 2. The patient ID is the only matching criteria but I need the names of the assigned nurse and the names of the staff who actually made the visits based on the ID number.

Thank you so much for this forum! You've saved me many times and my fingers are crossed that soemone know a formula, VBA, macro, filter... whatever will work. I need to rn these report every week so the ease of use is important but not essential.

Thank you!
Kelly