Macro - paste in filter search bar

[beekobeeko]

my table range is A2:E100
i need macro do the following
when i write some thing in Cell A1
it copies the content of A1 and open dropdown menu in Cell A2
then paste in the search bar

so i get all cells that contain ( not just equal ) what i wrote in cell A1

can i get help ?

[kev_]

Try in attached workbook

eg search for happy returns 2 rows

FilterBasedonCellA1.jpg


The code is all in the SHEET module

Please Login or Register  to view this content.

[beekobeeko]

thanks alot
i works very good