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! |
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! |
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! |
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! |
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! . |
making a cell a search/find field
|
All times are GMT +1. The time now is 08:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com