Hi to everyone. I have a little project and I hope someone could assist me
for this. I have a worksheet with four columns but the number of data exceeds
4000 rows. I understand excel can search using the function "ctrl+f" but what
I would like to achieve is that, I need to create a search box that would
return the matched keywords and highlight all data or matches in the
worksheet.
The worksheet would appear like this:
State City Institution Name Number

I tried creating userform that would search for the three fields state, city
and institution name and return all available information. Its like searching
data from the database. Can someone assist me on this?