I have a worksheet that has a filter applied to each column. I then use a macro to extract data from that sheet. Part of the macto will copy a name from a cell on another sheet, filter the name column and then copy a select number of records. To do this, the macro uses the filter on the name column, uses the "text filter = NAME" to filter the column.
My problem is that, if the search cell is FRED, the macro will return results with FRED, FREDDY, FREDERICK, etc. Basically, anything that starts with FRED.
I tried putting "" around the search cell (eg "FRED") but this didnt work.
Is there a way, using my existing macro that I can make it only find the exact match. The macro is very complicated, but hoping that I could either modify data in the search ceill or go in and edit the macro to make it find only exact match.