I have a workbook set up as a database in Excel. It stores rows of data (race results). I have another workbook which I use to extract data from that 1st workbook. To do this I have recorded a macro (using the record macro function in Excel). It searches for the name which is in Column A and has some other parameters such as date range and distance range, but it is the name search that I am having problems with. In the recorded macro, I have used the "TEXT FILER - EQUALS method when recording the macro. This works fine, except where names start with the same letters. For example, if I am searching for FRED ..... the macro will return results for FRED, FREDDY, FREDERICK, FRED BLOGGS etc within the other date and distance parameters.
Is there a way I can use something like quotation marks or some other way within the macro to make it ONLY find the exact match and not all the other derivitives. I cannot change the macro to some other method, because I have had somebody develop another program that runs that macro automatically for me as part of the process, so I would really like to stay with the macro but just make it find only exact matches. Is there a way to do that? I have attached a copy of the macro in txt format if that would help anyone solve my dilemma. Many thanks in advance for giving this some consideration.
Bookmarks