I've tried using VBA and while it does the trick, it is now actually what I'm looking for.
I need something that is automatic such that when I input the data in a cell, it will automatically filter the whole table based on that particular cell value.
What functions are out there that can do this trick?
Bookmarks