Have an urgent query.



I have a text box in an input form and depending on whatever the user
types in this text box, I wish to filter data in another sheet using the
"contains" text autofilter option.



For example, if the user types "oil", I wish to filter all the items in
"materials" column (next sheet) having "oil" in the description
(anywhere, in the beginning, middle or end).