Ecxel VBA

Hi, i would like to filter a table (5000+ rows, 20+ columns) with multiple criteria. More specifically, i would like to give a unique id ( 6digit NUMBER from the first column) and return ALL the oth...

excel

Formulas and Functions

Macros and VBA

NikolinoDE

Platinum Contributor

Aug 18, 2022

Kalogeros

VBA Code...

Sub AutofilterInput()
Dim Criterion1 As String, Range As Range
Set Range = ActiveSheet.UsedRange ' Adjust range accordingly
'Filter searches for "contains search text"
Criterion1 = "=*" & InputBox("Text you're looking for?", "Autofilter search term", "Search text") & "*"
If Criterion1 = "=**" Then Exit Sub
Range.AutoFilter Field:=1, Criteria1:=Kriterium1 'If several columns have an auto filter, adjust the field number if necessary
end sub

...or

Filter by using advanced criteria

Hope I could help you with these information / links.

NikolinoDE

I know I don't know anything (Socrates)