Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
making a cell a search/find field
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
making a cell a search/find field
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
making a cell a search/find field
What do you want to do with the data you find? If you want to, say, highlight
it, you can use Conditional Formatting (Format Conditional Formatting), using Formula is/=$A$1 "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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
making a cell a search/find field
I want it to keep column A1 held, which I can freeze and scrool and highlight
the found cell. Please assist more with that formula. I am a little unsure of how to enter it. Thanks "Sean Timmons" wrote: What do you want to do with the data you find? If you want to, say, highlight it, you can use Conditional Formatting (Format Conditional Formatting), using Formula is/=$A$1 "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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
making a cell a search/find field
I was able to locate the first post. Please point me in the direction.
Thanks! "Gord Dibben" wrote: 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! . |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
making a cell a search/find field
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a field value append a hyperlink | Excel Discussion (Misc queries) | |||
FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
Making one field equal 2 others | Excel Worksheet Functions | |||
Search range of cells, find a value, output adjoining cell. How? | Excel Worksheet Functions | |||
Find/replace search field defaults | Excel Discussion (Misc queries) |