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

[NBVC]

You were offered some solutions here in your previous thread.

http://www.excelforum.com/excel-gene...omparison.html

Please have the courtesy to respond there and continue on that thread.

[kelthomp]

Yes thank you. The suggestions did not work so I was hoping another user might have a suggestion for me.

[NBVC]

Then reply to that affect and why they didn't work on that thread.

Did you look at the attachments there?


I will now lock this thread.