I am presently have combo boxes with searchable drop down lists using excel formulas but the process is very slow
I am hoping that VBA can speed up the process but not sure how to do so
this is what I presently have
Column R: =--ISNUMBER(SEARCH(Sheet3!$I$10,Sheet14!A5172))
Column S: =IF(R2=1,COUNTIF($R$2:$R2,1),"")
Column T: =IFERROR(INDEX($A$2:$A$7000,MATCH(ROWS($S$2:$S2),$S$2:$S$7000,0)),"")
I also created a file name in the Comb Box properties / ListFillRange - managers : =Sheet14!$T$2:INDEX(Sheet14!$T$2:$T$7000,COUNTIF(Sheet14!$T$2:$T$7000,"?*"))
Is there VBA coding that would speed up the process and keep the searchable drop down list?