VB to filter table using text added to a cell

[scotthannaford1973]

Hi

I have a sheet "Folders" which has a huge table of data; I then have another sheet "Search" with a cell K11 into which I'd like colleagues to type a search term and for that to effectively be copied and pasted into a filter for "Folders" column C, so that whatever they type in Search!K11 and click onto a button, automatically takes them to "Folders" and shows the filtered results.

Hope that makes sense!

TIA

 

[DanteAmor]

Hi @scotthannaford1973, thanks for posting on the forum.

whatever they type in Search!K11 and click onto a button, automatically takes them to "Folders" and shows the filtered results.

Put the following code in a button on your "Search" sheet.
Type something in cell K11 of the "Search" sheet and press the button.

Sub searching()
  Sheets("Folders").Select
  If ActiveSheet.AutoFilterMode Then ActiveSheet.AutoFilterMode = False
  Range("C:C").AutoFilter 1, "*" & Sheets("Search").Range("K11").Value & "*"
End Sub

--------------
Let me know the result and I'll get back to you as soon as I can.
Cordially
Dante Amor
--------------

 

[scotthannaford1973]

Hi @scotthannaford1973, thanks for posting on the forum.



Put the following code in a button on your "Search" sheet.
Type something in cell K11 of the "Search" sheet and press the button.

Sub searching()
  Sheets("Folders").Select
  If ActiveSheet.AutoFilterMode Then ActiveSheet.AutoFilterMode = False
  Range("C:C").AutoFilter 1, "*" & Sheets("Search").Range("K11").Value & "*"
End Sub

--------------
Let me know the result and I'll get back to you as soon as I can.
Cordially
Dante Amor
--------------

That works beautifully - many thanks!