Making spreadsheet searchable w/o macros?
I’m looking to create a search box and possibly dynamic buttons like “filter” and “clear” as well within my spreadsheet. However, the problem is that this document will ultimately be shared widely and having people keep track of a macro file is really not realistic. So, I’m wondering what options there are to creation enhanced searchability within a spreadsheet without the use of macros. Is the sort/filter function the only option?
Thanks in advance!
I’m looking to create a search box and possibly dynamic buttons like “filter” and “clear” as well within my spreadsheet. However, the problem is that this document will ultimately be shared widely and having people keep track of a macro file is really not realistic. So, I’m wondering what options there are to creation enhanced searchability within a spreadsheet without the use of macros. Is the sort/filter function the only option? Thanks in advance! Read More