I have a need to compare two lists...a full list of all the club and
then a smaller list of club members with blue eyes. BOth lists have
names and eye colors.

However, one list was made by John who thinks that Mary Van Dahl needs
a space between the last name segments and the other list was made by
Carl who thinks that the space is extraneous and lists Mary VanDahl.
Of course, a sort puts these two names in different places. How do I
take the extra space out of John's list? And how do I completely make
them similar by removing all the capital letters ... i.e. mary vandahl

I want to do a manual sort by opening these two lists in completely
separate windows...no, I don't want to use the "window" functions of
Excel; for some reasons I have I want to open completely separate
windows. I can't figure out how to open a second Excel sheet in a new
window when there is already an Excel sheet open.

Even better, I'd like to compare the two lists and have the data in
John's list that has an equal in Carl's list put into a third sheet
with all the full data that John keeps (address, phone number, etc.)
that Carl does not.

Thoughts?

Jim