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.
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Search in conversations on Messenger not possible anymore
GentseGast -
kiransaini88 -

3 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses