I need help, my boss wants me to put together an excel doc. with 4 columns -A, B, C, D - that when you do CTR+F you only retrieve/search info jst from one column -B-. He wants to search only in that column; the reason is, we have info that is repeated throughout the other columns as well.
In addition, this excel doc also needs to be protected.
Research the "Range.Find Method" in the Help. This will help you build a macro in VBA to find values in a single column range. Or alternatively, use the Autofilter to find just those values you are looking for.