Hi all,
I've never found a great way to do tagging functionality in Excel. What I usually do is create a comma delimited list, and then search in filter on the tag I want to find rows for. However, I'm now creating a company-wide document and would like to leverage checkboxes to filter rows in the same way, as I think it's more user friendly for those less comfortable using Excel.
In some forum I found the attached macro, but I can't understand it well enough to see how to update it to work with my example sheet (also attached). Can someone help me out?
Note that because it's a comma-delimited list, the macro filtering logic would need to be updated to "contains" (just like the Filter search uses) instead of equals. For example, the row with tags "trends, statistics, thought leadership" and the row with tags "statistics, web performance" should both be returned when I check the box for "statistics" as a tag. If I were to check both "statistics" and "web performance" checkboxes, of course only the latter row should still appear.
Thanks!
Bookmarks