3 ms·
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 u
by iJohnDoe 5y ago
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.
- deleted 5y ago[deleted]