Need to add a search routine

  • Thread starter Thread starter Doug Little
  • Start date Start date
D

Doug Little

I would like to add a search routine to my spreadsheet.
It needs to be present at all times.
I would like to have it search one coluum

Any ideas?

Thanks
 
What would you like it to search for?
Will it always be the same column?
What would you like it to do if it finds the data?
What would you like it to do if it doesn't find the data?

Giving as much detail as possible up front will usually help you get to a
solution a lot quicker.
 
Select a cell in the column you want to search
ctrl-spacebar will select the column
ctrl-F will pop up the Find dialog.

In fact, you can add a Find icon to your favorite toolbar
tools|Customize|Commands tab|Edit Category
Find (with a binoculars icon)

Then you can select the column and hit this icon.
 
Thanks. This should work fine. Now..is there a way that
we can highlite the row or info when we find it?

Thanks
 
I think the previous answer helped out but I am always
open to other ideas.
I have a spreadsheet of 15 columns. I want to search for
info in 2 of those columns. If there is a find, then i
would like to have the cursor go to that row (as find
does now) and then highlite the row.
If it doesn't find anything, it can stay blank or give
some type of message.

Thanks for the help

Doug
 
Not quite the same as Search, but have you considered Autofilter? If it's of
any interest, then Debra Dalgleish has a good intro here:-

http://www.contextures.com/xlautofilter01.html

If you wanted to go a VBA (Macro) route, then you could have it do pretty much
anything.

Conditional Formatting can also be used in this context, and can be used to
highlight a row where the row contains a value or text that equals the value in
another trigger cell that you use to determine your search criteria. Again,
Debra has an intro:-

http://www.contextures.com/xlCondFormat01.html

Take a look, and anything specific we will gladly help to explain.
 
Back
Top