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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!