Searching for exact phrase in Excel

[Natalia132]

Can anyone help me with creating macros that would enable me to search.
I have a large excel spreadsheet containing multiple tabs with lists of company names. I would like to search for exact company name in all the spreadsheets.

Thanks in advance.

 

[Michael M]

Hi
You don't really need a macro to do your search.
Simply Press CTRL + F, then Options and Select Within "Workbook"

 

[Natalia132]

Hi
You don't really need a macro to do your search.
Simply Press CTRL + F, then Options and Select Within "Workbook"

I'm using one specific software that suggests that this company is mentioned in the document. But when I use Ctrl+F, it doesn't seem to find it.

 

[Michael M]

I can only suggest you look for errors in the typing or leading / trailling spaces.
If CTRL + F won't find the reasons would be either the above or....it isn't in the list.

When you did your CTRL + F, did you try it with "Match Case" and "Match entire cell contents" both UNchecked ?

You could also try using wildcards....So, if you were looking for Smithtown Inc you could put *town* in the Find text !