Good morning,

I have a number of bilingual Excel glossaries created from an export from a third-party app, which has 14 columns and >300 rows. I want to be able to search this table so that it filters in real-time as I type a term in an ActiveX text box (one for English, one for French).

I've found a way to do this using VBA, but I was hoping to be able to do the same using the =filter() function so I can work with normal Excel files and not have to share macro-enabled ones around my organisation. All the articles/videos I've seen on this feature reproduce matching entries from a dataset into a new cell/table, but that's not practical for me considering the size of my tables. So I guess my question is: can this feature be used to do the same function as my macro? If not, is there another feature I'm not aware of that can do this?

I have attached a couple of screenshots showing a dummy dataset and how my macro solution works. I can also attach the workbook if that helps (presumably not a .xlsm for security reasons...)

Thanks very much in advance for your help. I'd be happy to clarify if anything isn't clear.

dummy dataset.jpg

working macro solution.jpg