You already have a couple of replies to your first post.

Suggest you go read them.


Gord Dibben MS Excel MVP

On Thu, 22 Oct 2009 12:51:01 -0700, adam
wrote:

How do I make a cell a search/find field. For example, all the data is in
column A. I want to make A1 a cell I can put data in and have it search the
rest of the spreadsheet for that data. Is there a way to do this? I know I
could just do ctrl+f but this needs to be done hundreds of times a day and
eliminating that would be helpful.
Thanks!