Compare 2 Columns and Ouput Matches
Posted on 2013-06-16
I'd like to campare first name (column A) and Last Name (column B) on sheet 1 (named Registrations) to first name (column A) and Last Name (column B) on
sheet 2 (named Enrollments).
If a first and/or last name is found on sheet 1 that matches sheet 2, then output the sheet 2 match (first and last name) in a message box.
On sheet 1, I import names (to an excel spreadsheet) from people who've registered for a course - this comes directly from our registration system. The people who
registered will then need to also enroll at an online website to access their classroom. I keep track of both because I can't give them access
to their classroom unless they've registered.
They can enroll at the online website before they register but I will need to drop them from the online website if they don't register by the
course start date. I keep a list of people who enrolled at the website and didn't register on a seperate sheet. I'd like to know if the people
who enrolled at the online website are in the registration list that I import - without having to go back and look at it as I'm doing now.
I've noticed that some people are using different last names (maiden or married) when they enroll at the online website (this is because they don't update their
information in our registration system - we use unique IDs for users so unless they specify a change we look for the ID and process the
registration). This happens for returning users who have registered for a course before and didn't update their information.
This is why I'd like to compare the first name as well as last name since the first name may match but the last name may not. I hope this makes sense, thanks!
<<Question retitled and Visual Basic Class & Misc. Programming dropped from topic list--byundt, Microsoft Excel Zone Advisor 6/17/2013>>