Help! Find/search within text in Excel issue!

[Closed]
Report
-
 Ray -
Hello,

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.

CAN YOU HELP ME :( I'M LOST!

1 reply

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.