I have a sheet filled with research on trusts, where each row entry is categorized into 'priority' 'relevant' 'other' or 'irrelevant' which I select in one of my collumns.
Is there a way to produce a tab for each of these titles where the sheet then automatically only shows the data entries under that title?
I haven't used excel in a while and am having a bit of a mental block. I can figure how to do it with a macro and autofilters and copy and pasting, but I am sure there must be a simpler way!
Thanks![]()
Bookmarks