Help! Find/search within text in Excel issue! Closed

Question

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!

Configuration: Windows XP / Internet Explorer 7.0

Ray · Answer

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.

Help! Find/search within text in Excel issue!

1 response

Similar discussions

Subscribe To Our Newsletter!