Hi Sonal, I take a look on your data and find that your data in file1 and file2 are not same as there are some short names and no middle name in one of the file but the other one has full name and short middle name.
It can be done with VBA but if your data is not unique then there is no guarantee of right answer due to unmatched names in file1 and file2. Means it may give wrong answer if there are two Manoj in your data with different surname but same first surname letter or Any mukesh have same surname as Manoj and written in short form M Vartak. Regards Sandeep On Tue, Sep 22, 2009 at 10:28 PM, Sonal Gadgil <gadgil.so...@gmail.com>wrote: > Hi All. > > Please help me in this.... > > Thanks & Regards > Sonal Gadgil > > > ---------- Forwarded message ---------- > From: Sonal Gadgil <gadgil.so...@gmail.com> > Date: Mon, Sep 21, 2009 at 9:46 PM > Subject: Name Matching In Excel > To: excel-macros@googlegroups.com > > > Hi... > > I am new in this group. > > I am facing one proble while working in the excel. > > I am having two excel files where i have to map the customer based on > customer name by matching customer name manually. > > Now, in case there is any macro available which help me to search & map > names this will be great help to me & other users.... > > Example: > > > > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
