Turn on the macro recorder (Tools >> Macro >> Record New Macro). Accept whatever name it suggests (probably Macro1).

Select the range you want to search (so we can see how large it is, or how you go about figuring out what to select).

Do what you are asking for manually (use find, if it is not what you want, use find again, et cetera).

When finished, turn off the macro recorder (Tools >> Macro >> Stop Recording).

Now, find the code. To do this, use Tools >> Macro >> Macros, select your macro (whatever name from step 1), then click "Edit". This will open the Visual Basic Editor with the cursor at the macro you just recorded.

Copy everything from the word Sub to the words "End Sub".

Come back to this forum and post a reply to this thread. BUT ... before you paste the code here, press the # at the top of the window so that we can see the code in its native state.