Hello,
In my Excel there is a column, say, column A, where all the cells are text string such as company names. My task is to filter all the rows where the cells in column A contain the same company names. However, my problem is the company names was originally entered from different sources therefore for the same company it may be entered in different forms, such as for company ABC, it might be entered like ABC CO, ABC PTY LTD, or COMPANY ABC. There are also many other companies entered with the same problem. What I need to do is to find any word in Column A that shows up twice or more and filter all the rows that contains such cells in Column A.
I know this is a very hard task but just wondering if it is possible to do in in VBA? Your help would be greatly appreciated!
Configuration: Windows XP Internet Explorer 7.0
Use wildcards
|
I suppose it can be done by a macro. what you have to do is to extract a list of basic names of the companies in your database and filter and copy one by one by using a macro by automation. . For this you have to post small extract of your database and then one can create the macro.
|
Every workbook excel vba Excel vba basic tutorial Excel vba copy text Excel vba delete rows in table in access Excel vba drop down list form Excel vba finding max rows in a worksheet Excel vba format all cells on worksheet Excel vba formula view Excel vba if loop multiple columns Excel vba insert rows x number Excel vba select range of cells that contain Excel vba select rows Excel vba to create notepad Excel, if statement containing word How do insert date selection option in excel vba In excel vba copy rows until reach blank row Vba excel filtered range rows count Writing macro in excel to hide rows containing no value