+ Reply to Thread
Results 1 to 1 of 1

Help to get excel filter working properly

  1. #1
    Registered User
    Join Date
    08-13-2014
    Location
    Australia
    MS-Off Ver
    365
    Posts
    25

    Help to get excel filter working properly

    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.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Filter not working properly...
    By meus in forum Excel General
    Replies: 1
    Last Post: 06-22-2015, 05:49 AM
  2. Auto Filter not working properly
    By GEMINI528 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-20-2015, 04:46 AM
  3. copy using filter not working properly
    By hai_krk in forum Excel General
    Replies: 1
    Last Post: 07-05-2014, 03:14 AM
  4. [SOLVED] Copy not working properly Excel 2010
    By Flybridge in forum Excel General
    Replies: 9
    Last Post: 04-23-2013, 04:30 PM
  5. Excel 2007 : Exiting Excel is not working properly
    By amg78 in forum Excel General
    Replies: 9
    Last Post: 04-29-2010, 06:33 PM
  6. [SOLVED] Why is my tab key not working properly any more in Excel?
    By Steelman46 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-23-2006, 12:25 PM
  7. Auto Filter not working properly
    By Dale Fye in forum Excel General
    Replies: 1
    Last Post: 03-16-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1