How can I get exact returns in my search?

[blogger153]

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.

Many thanks

[TMS]

How would you have us suggest amendments to your code if you're not going to share it with us?

And a sample workbook would facilitate testing ...

[blogger153]

How would you have us suggest amendments to your code if you're not going to share it with us?

And a sample workbook would facilitate testing ...

The workbooks involve over a million rows of data and the combined books are more than 140Mb in size. I was hoping there was an obvious way to make Excel only find axact match when using the text filter = function.

[FDibbins]

Maybe use the LEN() function to ensure it only searches for x-number of chars?

[TMS]

I was hoping there was an obvious way to make Excel only find axact match when using the text filter = function.

There may well be but, unlike Ford, I won't be playing 20 Questions to second guess what needs doing.

You don't need the 140 Mb workbooks (bet that's quick), just a representative sample of non sensitive data.

[FDibbins]

@ Trevor - I agree, and I wasnt playing 20 questions, just have a single stab

[sktneer]

See if you can apply this logic to your current code.

[TMS]

I am sorry if I have offended you, which I clearly have.

More often than not, if an OP is reluctant to provide a sample workbook, the thread can take a lot longer to resolve, as trial and error solutions are rejected. It can generate a large number of inconclusive posts. Conversely, if a sample workbook with typical data and the current code is uploaded at the outset, a speedy and effective answer is more likely.

Hence my reason for saying that I don't want to play 20 questions. Perhaps I could have phrased that better. Again, apologies for that.

It seems that you have initiated 8 threads in this forum, 4 of which have been marked solved, 1 that was answered but not marked solved, 2 that were moderated, and the current thread. None of them appear to relate to improving performance, speed or efficiency. But maybe they are.

Whatever, I hope someone will be able to offer you a solution. Given the impression you have formed of me, it is probably better if I drop out now. Good luck.

Regards, TMS

[JBeaucaire]

@Blogger,

TMS is right. Any requests by someone offering to help here, for free, should be respected. The commentary between TMS and Richard reads playful and still trying to be helpful. No matter what you think you're reading, everyone here is actually trying to help and teach and make things occur quickly and simply.

I've removed your post above because you truly misread the situation and I don't think it needs to be here for the topic to be pursued to a positive conclusion.

TIP OF THE DAY - the moment you start to type a response that is not on the topic but is rather a comment on the PERSON of a prior post, you're typing a losing post. Don't do it. Just respond to the topic. If you're not going to provide something someone has asked for, even if you think it's dumb, just say "Thanks".