When I enter data in cell D2 in the yellow color of the TS column, the "book" table below from A3 to D13 will display the filter according to the value I entered. You edited it for me, thanks
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Filter data when typing suggestions
0
Discussion
There is no table by any name in your worksheet. To convert the named range "Book" to a table and click Insert > Table and follow the instructions. This is very similar to what I published here. Please take a look.
Variatus (rep: 4889) May 4, '20 at 3:25 am