MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

to see if text in a cell in a column is contained in any cell

  Asked By: Doan    Date: Dec 26    Category: MS Office    Views: 1299

I have a worksheet (worksheet 1) with names of companies in a

There is another work sheet (worksheet 2) with names of companies
and an identification number in another column.

However The names of the same company in the two sheets are not
exact matches. for example

In sheet the company may be called ABC plc while in sheet 2 it may
simply called ABC.

I am looking for VBA code which will look at each cell in worksheet
1 and check if that is contained (or equal) in any of the cells in
the name column in worksheet 2 (i.e has to loop through name column
in worksheet 2 to check) if a match is found it has to pick the
company name and identification number in another worksheet. or if
possible in worksheet i itself.



1 Answer Found

Answer #1    Answered By: Tia Hughes     Answered On: Dec 26

You can use LIKE operator in your VBA code. I'm sure this will resolve your