I have 2 sheets, The first sheet has Column A with Names (Last, First) and Column B Date (2012-03 etc.). The second sheet has very similar data. Column A with Names (Last, First Middle Initial) and Column B (2012-03 etc.). Some names have more date columns than others, I want to export these sheets into Access so I can match up dates but since some names have middle initials or Jr etc. in the name columns on the second sheet access does not match up the names. I have a 1000+ names and have doen it before it takes hours on hours to edit each name on one sheet to exactly match the other. Is there anyway I can get the names in the 2nd sheet to match the names on the first sheet since the names are very similar. I attached an example sheet that will make this much clearer. thank you for any help you can provide!Excel Forum Name Match.xls
Bookmarks