With all the searching I've done it would appear that you cannot embed a search function into a field on a workbook sheet;but it's more than possible I haven't looked in every place???
I'm working with Excel 2016 Pro. While I appreciate it's not rocket science to use Ctrl-F and many may consider this an unnecessary wish list item, the answer may well be Excel can't do it anyway. But I needed to ask!!
The environment where this would come into paly is with a couple of Excel registers we have; one being our membership list which has in excess of 25K members - one to a row. In an ideal world, I would like to have a field at the top of the register with 'enter search query' and next to that a 'Search' button. The user would enter the membership No, for example, and the Search button would act as a trigger (not unlike a hyperlink button) which, for all intents and purchases, does exactly what Ctrl-F does but the user avoids having to open a separate function.
Cheers
I'm working with Excel 2016 Pro. While I appreciate it's not rocket science to use Ctrl-F and many may consider this an unnecessary wish list item, the answer may well be Excel can't do it anyway. But I needed to ask!!
The environment where this would come into paly is with a couple of Excel registers we have; one being our membership list which has in excess of 25K members - one to a row. In an ideal world, I would like to have a field at the top of the register with 'enter search query' and next to that a 'Search' button. The user would enter the membership No, for example, and the Search button would act as a trigger (not unlike a hyperlink button) which, for all intents and purchases, does exactly what Ctrl-F does but the user avoids having to open a separate function.
Cheers