I have a tab delimited file that I bring into Excel. I need to review it on it a regular basis for cybersecurity reasons.

I load the file into Excel and then use the Excel Filters feature to get pulldown menus for each column. I then review the columns and filter for ports, user-agents, IPs, etc. Pretty typical stuff.

Anyone know how to automate the above that would basically just spit out files based on how I’m manually doing the filters? Then I can just open a file that is grouped by user-agents or open a file grouped by ports.

Thanks.