I hope it was easyish enough - sometimes I get a bit complex :P
@filex29
3 жыл бұрын
How do I create a partial lookup? E.g. Instead of typing “Snake Plissken” just type “snak or pliss”.
@anthonytruss7943
4 жыл бұрын
Thanks for the effort, this gave me something I can scale up and make what I'm envisioning. I like your explanation of the code as well; adding my own comments so I'll remember this later on helps too. Thanks again !
@1gopalakrishnarao
6 жыл бұрын
Excellent. Thanks a lot. Please do the same on multiple columns. Waiting for your magic. Thanks a lot once again. I love your presentation.
@TeachExcel
6 жыл бұрын
My new video is up and I think it's what you're looking for: kzitem.info/news/bejne/pYWNmYege5yYaX4
@ryankelly5642
4 жыл бұрын
Very informative and easy to follow. Thanks!
@andrewbirkhead7221
3 жыл бұрын
Instead of hitting 'Search' I'd like to show results as the user is typing. How can I do that? - And thanks, this is exactly what I'm looking for!
@garettwatts8126
4 жыл бұрын
Is there a way to make it search a single word and return a whole string of text? Like search an FAQ for the word "email" and bring back every Question or Answer containing the word "email"?
@enkhasper
3 жыл бұрын
Please share if you found an answer :)
@garettwatts8126
3 жыл бұрын
@@enkhasper Sub Searchable_List_Simple() Dim MainSheet As Worksheet Dim MyTable As ListObject Set MainSheet = Sheets("Dashboard") Set MyTable = MainSheet.ListObjects("Thor") UserInput = MainSheet.Range("C5").Value FieldName = MainSheet.Range("C9").Value If UserInput "" Then MyTable.AutoFilter.ShowAllData If FieldName = "Question" Then MyTable.Range.AutoFilter Field:=1, Criteria1:="=*" & UserInput & "*", Operator:=xlAnd ElseIf FieldName = "Answer" Then MyTable.Range.AutoFilter Field:=2, Criteria1:="=*" & UserInput & "*", Operator:=xlAnd End If Else MsgBox "Yo man, input something!" End If End Sub Sub Clear_Filters() Dim MainSheet As Worksheet Dim MyTable As ListObject Set MainSheet = Sheets("Dashboard") Set MyTable = MainSheet.ListObjects("Thor") MainSheet.Range("C5").Value = "" MainSheet.Range("C9").Value = "" MyTable.AutoFilter.ShowAllData End Sub
@enkhasper
3 жыл бұрын
@@garettwatts8126 Thanks! :) Also found I could simplify: "=*" & UserInput & "*" to "*" UserInput "*" - at least for my columns
@voiceforanimalsrescueandsa2229
2 жыл бұрын
I am finding this easy to do. We are 501c3 rescue and finding names are in a database on approved/denied is always needed with the reasons. There are several other uses for it as well. I am just curious to know if I can add names to the table as time goes and do not understand what file I am supposed to download to activate the buttons with the macro as you say, "this file".
@nathandancy2608
3 жыл бұрын
2 questions: Can I pull partial results? (i.e. - not exact matches) and How can I get this VBA to run in my workbook WITHOUT opening your 'Searchable List' workbook? (What did I do wrong?)
@producer_ben
2 жыл бұрын
I realise this is old from 2018, but I'm finding it useful. The only thing I cannot find is the VB code you say to download. I have download the excel sheet you linked, but I cannot see the VB code in there. Any help please?
@anthonytruss7943
4 жыл бұрын
Do you have a method where partial search can be conducted? If I was searching for the number 507; I'd want to see multiple part numbers that contain the number 507 within; part numbers would be M507-02-11 where it would identify 507 and filter that result. I looked into wild cards but I don't think it would work with a macro. Any help would be much appreciated.
@enkhasper
3 жыл бұрын
I have the same question. Have you found an answer?
@rekey5716
5 жыл бұрын
Hi, its great One thing if spelling is misspelled its shows blank, kindly tell something so that it gives near result also
@hassansahidsesay3194
8 ай бұрын
I need the advance version that involves more coding
@joyliu9264
2 жыл бұрын
I couldn't make it work, can you help, it keeps coming up error, (Set My table = MainSheet.ListObjects("Mytable"))
@Dilumi24
4 жыл бұрын
please be kind enough to do a video regarding hierarchy charts
@SteamDougy
4 жыл бұрын
Should I try this with no prior experience in Excel?
Пікірлер: 22