Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro for search tool with multiple entries
Hi guys,
I am looking for a Macro that works similarly (*) to the Excel Search tool: you enter a text in the message box and the tool looks in each and every cell of that sheet and go to the cell/s where it finds the text. (*) The only diference is that I would like to do a multiple text search. For example y would like to be able to enter 2 words (eg. ball and match) and that excell looks for and go to the cell that have those 2 words, no matter of their order ball match, match ball, matchball. The same for 3 words criteria. Thank you. Regards, |
#2
|
|||
|
|||
Quote:
I only have it set to search in the current sheet - i think |
#3
|
|||
|
|||
That´s awsome shanermuls!!
Thank you very much!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bottom Up search for multiple entries | Excel Programming | |||
Using SEARCH in a single cell to COUNT multiple entries of same te | Excel Programming | |||
Using SEARCH in a single cell to COUNT multiple entries of sam | Excel Programming | |||
Using SEARCH in a single cell to COUNT multiple entries of same te | Excel Programming | |||
Search For Multiple Entries - Combine and Sum | Excel Programming |