Previous Topic Next Topic

Help! Find/search within text in Excel issue!

Closed
Patricia As - Aug 30, 2010 at 10:36 AM
 Ray - Aug 30, 2010 at 05:46 PM
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!

Related:

1 response

Answer 1 / 1
Ray
Aug 30, 2010 at 05:46 PM
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.

Similar discussions

Ghost mail
WondrousCrocodile61 -
HelpiOS -

1 response
How to convert number into text in Excel
boratechandu -
Raj -

9 responses